Bill Johnson
Bill Johnson

Reputation: 303

VLOOKUP from another worksheet

Could someone please assist me with the following VLOOKUP query.

I have data in Column A on one spreadsheet and I need to match the data that is contained within this column, against Column A in another open spreadsheet and if they match populate Column B in the first spreadsheet with the data contained with Column B in the second spreadsheet.

Can anyone assist as I'm not sure of how to achieve this?

Upvotes: 0

Views: 3939

Answers (1)

Dan
Dan

Reputation: 45762

in cell B* in sheet2 (where * is the row number) =vlookup(A*, 'Sheet1'!A:B, 2, FALSE)

Upvotes: 1

Related Questions