Forum Discussion
Solved
help with vlookup (index small) to show nth row when one of 2 criteria match
i am using the below formula to identify the cell O5 (nth) match =INDEX($I$8:$I$801,SMALL(IF($L5=$C$8:$C$801,ROW($C$8:$C$801)-ROW($C$8)+1),O5)) The issue is i want to edit this formula in a way that...
perfect thanks
=INDEX($I$8:$I$801,SMALL(IF(($L5=$C$8:$C$801)+($L6=$C$8:$C$801),ROW($C$1:$C$792)-ROW($C$1)+1),O5))Is this what you are looking for? Enter formula with ctrl+shift+enter if you don't work with Office365 or 2021.
perfect thanks