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

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.


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

 


46.1 - 806,126
Scroll down for Comments
0 0 votes
Article Rating
Subscribe
Notify of

This site uses Akismet to reduce spam. Learn how your comment data is processed.

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x