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
a 6ya Technician can help you resolve that 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 repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
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: