Forum Discussion
katie
Sep 01, 2018Copper Contributor
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 ...
jrosent
May 27, 2022Copper Contributor
I believe I have a similar problem.
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 data points for corresponding name.
If the name in Sheet 1, Column B matches the name in Sheet 2, Column A and the date in Sheet 1, Column C matches the date in Sheet 2, Column C then the data in Sheet 2, Column B needs to be added to Sheet 1, Column A.
Each listing of a name comes from a different month in which data was pulled. The month is listed in Sheet 1, Column C.
That being said, each data point is different and needs to match up with the name and month when added to Sheet 1, Column A.