Forum Discussion
Solved
Index and Match
Can someone help me with my issue? I only want to display companies from sheet one on sheet 2 that have a match for cell A1 on sheet 2. Current workbook formulas. Sheet 1 last column, =IF(IS...
=IFERROR(INDEX('Sheet 1'!A2,MATCH($A$1,'Sheet 1'!$C2,0)),"")Unfortunately from your initial question i didn't understand that there are 48 sheets in your workbook. I tried above formula for several companies and sheets in the attached file and it seems to work.
=IFERROR(INDEX('Sheet 1'!A2,MATCH($A$1,'Sheet 1'!$C2,0)),"")Unfortunately from your initial question i didn't understand that there are 48 sheets in your workbook. I tried above formula for several companies and sheets in the attached file and it seems to work.
Thank you very much, this did the trick. I apologize for the confusion. I tried to get the intent as clear as I could.