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 Katie,
That could be like
=IFERROR(INDEX(Sheet2!$B$2:$B$10,MATCH(Sheet1!$B2,Sheet2!$A$2:$A$10,0)),"")
and attached
Please could you help.
I would like to compare data on sheet 1 (A3:A1065) & 2(B2:B279) and if they match to return a specific value from sheet 2; Column D onto sheet 1, Column C - along side the matching information - if there is no match in the array to return NO as a value in sheet 1, Column C.
I hope thats understandable and you can assist
Not sure I understood how the data is structured. As variant
=XLOOKUP($A$3:$A1065,Sheet2!$B$2:$B$279,Sheet2!$C$2:$C$279, "No" )