Forum Discussion
If cell matches cell in range of cells matches input data from other cell
I need a formula that will check a cell value against a range of cells and if that cell value shows up in that range I want the cell to contain the data from another cell. I provided a link to my te...
Please try this...
On All Accounts Sheet,
In F2...
=IFERROR(INDEX('Product Type'!B:B,MATCH(G2,'Product Type'!A:A,0)),"")and copy it down.