Using VLOOKUP and MATCH functions

[Wizza]

Hello,

I have 3 columns of data (A,B,C) the 4th is where I will output the answer to my question.

In 2 of the columns (A & C) I have the data I want to match. I want to match each name and then output the number in column B1 which is adjacent to the matched name in column A. So, if I wanted to match the name John, then cell D1 would output the value 4. Since that number is next to or adjacent the matched name in column A. Cell D2 would output the number 5, since that is the number adjacent to the matched name in Column A. etc

A B C D

Jenny 5 John
Bob 3 Jenny
John 4 Bob


Thanks

 

[JackDanIce]

Welcome to the board. In D1 try:

=VLOOKUP(C1,A:B,2,FALSE)

 

[Wizza]

Thanks, works perfectly. You are a legend !!!