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.
it is closer to what i need. i have 48 companies. there will be a worksheet for each company. the first sheet will have all the companies and their rows in a data dump. i need to see the data for each company on each sheet. every sheet will have the company name in cell A1. your solution only shows the same company on every sheet.
=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.