Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup against one of two columns
I have a spreadsheet which allows a sales rep to enter a part number and have the price column populated - normal vlookup works fine for this. However, the lookup table contains 2 part numbers (ours and a competitors) and I want them to be able to enter either of those codes and have the price populated Col A Col B Enter code: Price 123 OR xyz £1.99 Lookup table is: A B C Code Code2 Price I'm not sure whether i should be using Match, Index or VLookup for this, so any help much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup using two columns | Excel Worksheet Functions | |||
adding three consecutive columns | Excel Worksheet Functions | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
vlookup for multiple columns | Excel Worksheet Functions | |||
VLOOKUP won't work | Excel Worksheet Functions |