Thread: look up a value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sjl
 
Posts: n/a
Default 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.