Using Vlookup (and perhaps MATCH)

[Excel_Fan]

Hello,

I have a 3 Columns A, C and E.
In cell B1, I want to check if the values in A exist in C. If they do, i would like to return the value of E.

For example let's say Bob is in A3. I searched column C for Bob and found it in in C8. In B3, I would like to return the value of E8 (basically I want to keep the row value the same and return the value in E).

So far i have
=IF(VLOOKUP(column A,column B,1,0)= TRUE,1,return value in Column E)

I just dont know how to return the value in column E.


Thanks,
Excel_Fan

[NBVC]

Try:

=INDEX(E:E,MATCH(A1,C:C,0))

or

=VLOOKUP(A1,C:E,3,FALSE)

To avoid the #N/A error you can wrap either formula with a test... e.g.

=IF(ISNUMBER(MATCH(A1,C:C,)),VLOOKUP(A1,C:E,3,FALSE),"")

[Excel_Fan]

Thanks.

I used =INDEX(E:E,MATCH(A1,C:C,0)) to get what I needed. This was very useful. I'll read up about index and see its uses. i had arrange the number in a way where they matched type as well. But it eventually worked out.

Appreciate the help.

Excel_fan