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 the 2nd largest stock price if the asset class is equity. There are multiple asset classes so there is a column that contains whether the security is in equity, fixed income, etc. Thinking I need to use the LARGE function nested within an INDEX MATCH. Please help, I'm begging.
12 Replies
=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 gives me an n/a
Perhaps you may drop small sample file or at least screenshot?
- unfortunately this this gives me n/a
