Question about Microsoft Excel for PC
Hi, Could you please tell me how you want to compare the two sets of figures. Do you want to find a figure in column A and retunr the corresponding from column B or apply some other question on the data?
Posted on Mar 07, 2008
I am not sure if Vlookup is the right function to use in this case.
A simpler approach may be to use an "IF" statement.
For example, with a data set:
A B 3 17 765 23 8645 45 43 87 634 635 34 31
Let assume you wanted to compare if A was greater than B and if true return B. If false return a 0.
The results would look like this:
A B Results 3 17 0 765 23 23 8645 45 45 43 87 0 634 635 0 34 31 31
Posted on Feb 28, 2008
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Mar 14, 2011 | Microsoft Excel for PC
Feb 18, 2009 | Microsoft Computers & Internet
Feb 11, 2009 | Microsoft Excel for PC
Dec 10, 2008 | Microsoft Excel for PC
Jul 27, 2008 | Microsoft Computers & Internet
Jul 12, 2008 | Excel (SS8SATAS5128400R)
Feb 03, 2008 | Microsoft Excel for PC
Aug 30, 2007 | Microsoft Office Standard for PC
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
61 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: