Forum Discussion
Cross Referencing Data in Excel
Hello, I have a spreadsheet that lists document numbers that are stored in a document management system. I have to cross reference the documents in that management system, which means I have to go ...
=IFERROR(INDEX($B$2:$B$162,SMALL(IF($C$2:$AP$162=$C$166,ROW($2:$162)-1),ROW(A1))),"")
This formula returns the expected results in my sample file in my understanding. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021. I've added conditional formatting which highlights the cells in range C2:AP162 where search string from cell C166 is found.