Forum Discussion
Match Cells on Sheet 1 & 2 and return value from a cell on Sheet 2 to a new cell on Sheet 1
Sheet 1, Column B lists names. Same names are listed multiple times. Sheet 2, Column A lists one name and Sheet 2, Column B lists phone # for corresponding name. If the name in Sheet 1, Column B ...
Hi HMills8475 I am attempting almost similar but cannot get it to work. I hope you can notice this and help.
If the value in column B is in Sheet 1, column I, return x. But if the value in column B is in Sheet 2, column c, return y.
If the value in column B is in Sheet 1, column I, return x. But if the value in column B is in Sheet 2, column c, return y.
On Sheet2 I have a list of names and their info COL B Last name, COL C First name, COL D phone, etc.
On Sheet1 I want to enter last name in Cell C2, and I want cells D2, E2, F2, etc., to automatically populate with the corresponding data for that particular person that is on Sheet2 in COL C, D, E, etc.
Could you tell me how to do that please?