Display contents of adjacent cells

N

Nigel Sunley

I am using the MIN formula to display the lowest value in a range of cells.
What formula can I use to display the contents of the cell adjacent to
whichever cell is selected as the lowest value e.g.:

A 1
B 2
C 3
D 4
E 3
F 2
G 1

Using MIN will show "4" but how can I also display the contents of the cell
to the left of the minimum value (in this case "D")
 
S

Stefi

In my example I used columns G and H:

=INDEX(G1:G7,MATCH(MAX(H1:H7),H1:H7,0))

NB. 4 is MAX of your range!

Regards,
Stefi

„Nigel Sunley†ezt írta:
 
N

Nigel Sunley

Thanks very much it works well & I will just have to avoid confusing MIN with
MAX!
 
S

Stefi

You are welcome! Thanks for the feedback!
Stefi

„Nigel Sunley†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Trying to find additional ranges outside of min, max, and average 2
Event recognition. 11
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Cell reference in formula string displays abbreviated value 2
Countdown macro - display settings 2
Visio: copy text of a master shape to User-define Cells (Variable) 0

Top