Matching 2 Columns with a Pre-defined 3rd as a Result

Good evening,

First, I've been trying to find a solution on Google for a problem similar to mine but have been unsuccessful in my hunt, so I've resorted to asking you guys since you seem like you know what you're talking about. I don't have much time - if I did, I'm sure I would eventually find a solution.

Anyway, this is the issue I'm having: I have two sets of data. Data A consists of 2 columns (Flight Name, Website) and Data B consists of 1 row (Flight Name). The 'Flight Name' column from Data A and Flight Name column from Data B consist of airline names in random order, most of which match each other. The values from 'Flight Name' column in Data A have corresponding values in the 'Website' column, also in Data A.

I need to get corresponding 'Website' values (from Data A), of the values in 'Flight Name' (Data B) that match 'Flight Name' (Data A), into Data B.

Please keep in mind that both sets of data have no less than 4,000 rows.

I have drawn it out below.

Thank you very much for your time.

Zain

Originally Posted by martindwilson

please dont post images post a sample workbook

I have attached a sample file, as per your request. Again, please assume that all three lists are much larger in actuality.

Zain

Originally Posted by martindwilson

in e3
=VLOOKUP(D3,$A$2:$B$2000,2,FALSE) fill down

Thank you very, very much.