Forum Discussion
Index Match
I need to find a way to find a way to use index match or another lookup function to pull the 1st, 2nd, 3rd, 4th, 5th largest number from a data set based on a criteria. For example, I want to find th...
=LARGE(IF($C$2:$C$25=H$4,$D$2:$D$25),$F5)You can try this formula for the dataset of the attached example. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
unfortunately this this gives me n/a