| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look up a value
Works great, thank you.
sjl "Ashish Mathur" wrote: Hi, Try the following index and match formula =index(A1:E5,match(C1,A1:E1,0),match(A2,A1:A5,0)) Regards, "sjl" wrote: 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. |
Threaded Mode
