return nth highest number after search criteria met

[fpgary]

In the attached worksheet (Tab2, D21) I am trying to return the 2nd largest number from the data present in Tab1. The search should look at the data in Tab1, column 4 with a result of "2" again returning the 2nd highest number. Correct value should be -11.


In Tab2, D30 it should return the 2nd highest number but only considering the data in Tab1, column 4 with a criteria of "3". Correct value is -6

Thank you in advance.

Gary

[FlameRetired]

1. =LARGE(IF('Tab2'!4:4="2",'Tab1'!10:10),2) The "" around the 2 renders the 2 as text and not a number. The data types must be the same.
2. I find neither of these. Correct value should be -11. Correct value is -6
3. Are you sure this is the correct workbook?

[fpgary]

Thanks Dave, yes it worked. I first tried in my original workbook and it works and then I came back to my uploaded attachment and it works there as well. I had the formula in my attachment incorrect but once I fixed it it does return a -11. Should have been {=LARGE(IF('Tab1'!4:4=2,'Tab1'!10:10),2)} instead of {=LARGE(IF('Tab2'!4:4=2,'Tab1'!10:10),2)}. Thanks again.

Gary

[FlameRetired]

You are welcome. Glad to help. Thank you for the feedback, added rep and marking your thread Solved.