I am trying to look up the top 10 values in California (or "CA" in the example) and then return them into a different sheet.
In the attached example, I would like Sheet 1, F5, to have the largest value in California, having looked up from column H in sheet 2. I would then like the second, third, fourth etc. largest values down to 10.
Sheet 2 - look up column H for "CA", return value in column C.
Columns D and H both have formulas in.
I've tried Large, IF. INDEX, Large, IF and can't get anything to work.
Any help would be greatly appreciated!