«

»

Mar 12 2017

Excel: How to Find Data in Sheet 2 that Relates to Data in Sheet 1

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) ]

 

For Books with Free Delivery Worldwide: BookDepository UK and USA

Leave a Reply to this Posting, but no links please.