Thread: look up a value
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sjl
 
Posts: n/a
Default look up a value

Thanks, i've got it working now.
sjl

"Peo Sjoblom" wrote:

http://www.contextures.com/xlFunctio...ml#IndexMatch3


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"sjl" wrote in message
...

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.