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.