Hi all,
I have three columns of data - I need to be able to look up the 4 highest values in column B and return the corresponding text from column A and monetary value from C(in different cells).
Can anyone help?
Sample data:
A1:A3
Red
Blue
Green
B1:B3
2
5
3
C1:C3
£100
£300
£700
In this example, I would need a formula to return 5(in say E7), Blue(in F7) & £300(in G7)
Apologies if I haven't explained too well!
Thanks in advance
I have three columns of data - I need to be able to look up the 4 highest values in column B and return the corresponding text from column A and monetary value from C(in different cells).
Can anyone help?
Sample data:
A1:A3
Red
Blue
Green
B1:B3
2
5
3
C1:C3
£100
£300
£700
In this example, I would need a formula to return 5(in say E7), Blue(in F7) & £300(in G7)
Apologies if I haven't explained too well!
Thanks in advance