if column D is a maximum, give me column G

[AaronR882]

I have a column of numbers which uses conditional formatting to highlight the max value, but i want excel to find the highest value in a column and give me the corresponding value in another cell.

In the attached document I want the value in column G which is in the same row as the Max value in column D

My thinking is "if column D is a maximum, give me column G"

So i used the formulas :
=IF(MAX=G3:G363, D3:D363)
=IF(G3:G363=MAX, D3:D363)

[jason.b75]

The easiest way would be

Please Login or Register  to view this content.

If there are multiple rows containing the same max in column G then this will return the corresponding value from the first one found.

[KOKOSEK]

	b	c	d	e	f	g
242	239	19.9	0.0609	0.0240	0.0369	529.7396
243	240	19.9	0.0608	0.0240	0.0368	529.9554
244	241	19.8	0.0606	0.0240	0.0366	529.7073

CF formula for column D:

Please Login or Register  to view this content.

[AaronR882]

These both work, Thanks a lot.

*For others: If you are wanting this to work with values across worksheets finish the formula off as an array formula "ctrl + shift + enter"