I have two work sheets I'm using.
Sheet1!A column contains a list of customer names like "Smith, John".
Sheet2!A contains the same list of name with additional information found in the row. For example, you will find "Smith, John" in Sheet2!A3 and John's phone number in Sheet2!B3
In Sheet1!B it to find the associated telephone number based on matching criteria from Sheet1!A and Sheet2!A
For example, Sheet2 has the following data.
On Sheet1 I have the following names. You'll notice some of the names repeat.Please Login or Register to view this content.
In column Sheet1!B I would like it to scan column A from sheet2 and display the data show in column B. So it would look like this-Please Login or Register to view this content.
You'll notice some names repeat but it always displays the correct number from Sheet2.Please Login or Register to view this content.
How would I accomplish this?
Bookmarks