Thread: Finding Cell reference after a "max" command

I have a spread sheet containing laboratory test results. Using the MAX command I select the maximum value from a range of cells. I now need tob automatically select other data from cells in the same row as the selected max value.

ie If cell C300 contains the maximum value I need to automatically select data from cell G300, input both value into a table and use the values to calculate a result. This is done for 10 sets of data within the sprfeadsheet.

How do I find the cell reference for the determined maximum value so I can select other data from the same row?

Any ideas please

Use a combination of the MAX, MATCH, ADDRESS, and INDIRECT functions (See attached example).