Find the nth largest value and return the value in another column

[gberg]

I have a table and want to find the nth largest value but then return the result from a different column in the same row the nth value is located in. I have a large table so this is a small example

Object	#		n	Result
Orange	54​		1	Pineapple
Apple	35​		2	Pear
Pear	68​		3	Orange
Grape	1​
Pineapple	548​

The table would be "Object" and "#" (Table A) and the results would be the N and Results


I would want to look for the largest value in the "#" column and return the result from the "Object" column. In this case it would be Pineapple with 548. It would go down the list and look for the second largest value (68 / Pear) and so on.

Thanks for any help you can give me.

Greg

 

[Fluff]

Glad we could help & thanks for the feedback.