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