Thread
:
Multiple V-Lookup
View Single Post
#
2
Posted to microsoft.public.excel.misc
Luke M[_4_]
external usenet poster
Posts: 457
Multiple V-Lookup
Perhaps something like:
=INDEX(Sheet2!C:C,SUMPRODUCT(--(Sheet2!A2:A100=Criteria1),--(Sheet2!B2:B100=Criteria2),ROW(A2:A100)))
--
Best Regards,
Luke M
"Vlookup Function" <Vlookup
wrote in
message ...
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
Reply With Quote
Luke M[_4_]
View Public Profile
Find all posts by Luke M[_4_]