Need to catch highest value plus data on same row.

[Tinny426]

Hi all,

This is probably simple for most.....

I have a column of numbers and i know the formula to get the highest value, but i also want

the data from a different column on that row that has the highest value.

Hopefully you can understand below.

 

[#2]

@Tinny426 Rather than just providing a bunch of formulas in text, please find a working example, based on your screen shot, in the attached file.

[#3]

Thanks heaps for your help on this, much appreciated.:thumbs_up:
Cheers Richard.