Thread
:
look up a value
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
sjl
Posts: n/a
look up a value
A B C D E
1 3 6 9 12
2 5 SAM
3 10
4 15
4 20
How do I search for the intersection of "5" and "9" to get "SAM". I cannot
use a vlookup because the column i am searching changes.
Reply With Quote