Alex,



To match both "Joe" in Range1 and "Jones" in Range2, and return the value in
"ValueRange"



=INDEX(ValueRange, MATCH(1,(Range2="Jones")*(Range1="Joe"),0),0)



Enter as an array formula



"alex" wrote in message
...


Hi..

Normally for vlookup u would look for a single value. now
i want to use 2 cells to do a vlookup.
i tried looking on net ... i found something using index
and match. i didnt clear understand it.pls do tell me the
easier way out or maybe i am using a wrond approach

pls suggest
thanks