V Lookup / Index Match

[Tingle]

Hi there,

I am having trouble getting a formula to work.

I have two spreadsheets within one workbook. The first one has a list of Postcodes. The second one has Post Codes and names.

I need to pull the names through from the second spreadsheet over to the first one. So ideally it will search through the whole list and then cross match and provide the name.

Is this something that can be done?

Thanks

Tingle

 

[Nine Zero]

Assuming your postcodes are in column A on both sheets and the names on sheet 2 are in column B and you want to return your result to column B of sheet 1

in B1 do

=VLOOKUP(A1,Sheet2!A:B,2,0)