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
I have an Excel file with two sheets. All data stored in sheet 2 in row and column index.
In sheet 1 I need some data just like rows and columns but not all rows and columns.