I want to find data in an Excel sheet 2 that relates to data in sheet 1
Sheet 1 column A contains various names.
Sheet 2 Column A contains all the names and column B contains a reference number for that name on the same row.
What I want to do in Sheet 1 column B is look at Sheet 1, A1, compare that to the names in Sheet2, A:A, and return the value of Sheet 2 column B for that name.
The answer is:
Place the code =VLOOKUP(A1, Sheet2!A:B, 2, FALSE) in sheet 1 cell B1, and other relevant cells in column B.
This looks at A1 in sheet 1, compares that data to data in column A of sheet 2 and returns the value in column B of the relevant match, by use of the number 2 just before FALSE. You could use a wider range of columns, say A:D, which allows 4 columns, and you could select D by using the number 4, eg: [ =VLOOKUP(A1, Sheet2!A:D, 4, FALSE) ]