Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple VLOOKUP
I have an array 3 x 20
when I do a VLOOKUP. I look far a matching value that comes fro column 1 and return what is found in column 2. this is fine but what I would like to do is be able to also check wha is in column 3 to generate the result. how can you "and" the lookup? I need to say. if it matches column 1 AND 3 then give the result fro column 2 is this possible? thanks Pab -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum multiple vlookup returns across multiple columns | Excel Worksheet Functions | |||
Vlookup multiple criteria multiple occurrences sum values | Excel Worksheet Functions | |||
Vlookup with Multiple criteria and multiple sheets | Excel Worksheet Functions | |||
Vlookup for multiple criteria, multiple worksheets | Excel Worksheet Functions | |||
How do I use VLOOKUP to ref multiple workbooks with multiple tabs? | Excel Discussion (Misc queries) |