Matching 2 fields in 2 columns and copying a 3rd field into the 3rd column

Hi All,

I'm new to Excel...I'm sure you've read that enough times on this forum.

I need help with a formula. Probably Vlookup. I'm having a LOT of trouble trying to figure out how to "phrase" the formula so let me explain what it is I'm trying to do.

If a cell in Sheet 1 Column AS and a cell in Sheet 2 Column B match exactly, I want the cell in Sheet 2 Column C that is in the same row as the matched cell in Sheet 2 Column B to be copied into Sheet 1 Column BB in the same row as the matched cell in Sheet 1 Column AS.

For example, if cells in S1 Column AS and S2 Column B both have the name "LOS ANGELES" then "KLAX" will be copied from cell in S2 Column C (in same row as "LOS ANGELES") to S1 Column BB (in same row as "LOS ANGELES").

Oh my, I hope that was clear enough. Please help me!

=Vlookup(AS2,'Sheet2'!B$2:$C$100,2,FALSE)

where AS2 has a value "Los Angeles" to look and find in B2:B100 on Sheet2 and then return "KLAX" which is corresponding cell in column C of Sheet2

adjust sheetname and ranges to suit.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save