Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine Vlookup and If?
I have 2 lists, in one list I have a customer num, invoice amt, and some
other data (In columns A, B, C, etc). On other sheet I have a second list which also contains customer num, Invoice amt, other data. This information is not always the same on both sheets. I need a formula that will find a customer from sheet 1, look up the customer num on sheet 2, then compare their Invoice Amounts. What I did was to create a vlookup to compare the companies, which returned the invoice amount, in the next column I added an =IF(B2=C2),"same", different" Is there an easier way? Suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup combine indirect | Excel Worksheet Functions | |||
combine Vlookup with the Right function | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Possible to combine VLOOKUP and IF(AND) functions? | Excel Worksheet Functions | |||
How do I combine If and VLookup function? | Excel Worksheet Functions |