Forum Discussion
How do I use a cross reference cell to populate data from one excel sheet to another
I'm wondering if this can be done. This project will take days if not. I have two spreadsheets. I need to merge data from one to another in a specific location. Column A in both sheets have phone nu...
=IFERROR(INDEX(Worksheet2!$E$2:$E$78,SMALL(IF($A2=Worksheet2!$A$2:$A$78,ROW(Worksheet2!$A$2:$A$78)-1),COLUMN(Worksheet2!A$1))),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. In the example the formula is in cell AC2 and filled across range AC2:AH27.