Reputation: 303
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
Reputation: 45762
in cell B* in sheet2 (where * is the row number) =vlookup(A*, 'Sheet1'!A:B, 2, FALSE)
Upvotes: 1