thanks madhu, but I already got the answer from T Valko. Your formula is
giving the result as 4, which is not correct. However thanks a lot. You all
are genius.
nsd

"muddan madhu" wrote:

try this

=INDEX(C1:C5,MATCH("jan",A1:A5,0)*MATCH("john",B1: B5,0),0)



On Sep 23, 1:18 pm, nsd wrote:
I have some data as under

A B C D
Jan John 2 3
Feb Peter 3 4
Mar John 4 2
Apr Dan 2 3
May John 3 2

What should I do to Vlookup for John for the month of Jan to get the desire
result from column c i.e. 2