Forum Discussion
Excluding Rows from Index Match Results
Hello, I work for a operations team that uses a software to track their work every week and we have a report we drop an exported CSV into every week. One of the outputs from the report is a bott...
=SMALL(IF(($A$2:$A$24<>"Manager"),$C$2:$C$24),ROW(D1))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.
=INDEX($B$2:$B$24,MATCH(F4,$C$2:$C$24,0))This is the formula in cell G4.
=INDEX($A$2:$A$24,MATCH(G4,$B$2:$B$24,0))This is the formula in cell H4.