Multiple V-Lookup
Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula}"
returns matching value from Sheet2 colC based on the match from Sheet2 ColA
and Col B
=INDEX(Sheet2!$C$1:$C$10,MATCH(1,(Sheet2!$A$1:$A$1 0=criteria1)*
(Sheet2!$B$1:$B$10=criteria2),0))
--
Jacob (MVP - Excel)
"Vlookup Function" wrote:
I am trying to do a Vlookup function that will look at 2 cells on the same
row in one tab and find that in the workbook on the other tab in the same row
and then spit back a number from a different cell.
It's like a regular vlookup but i'm trying to search for 2 values in 2
different cells at the same time.
Is this possible? Maybe it's not even a vlookup i should be using.
The problem with using an if(and()) statement is i can only search for the
combination 1 row at a time, so if it doesn't line up, i won't get a match. I
need to search the whole workbook.
If anyone has any ideas, i really appreciate the help!
Thanks,
Rachel
|