Lookup when values located in a row across bottom of table of data
 

Hello,

I am trying to get a reference to a cell that is in the same column as
a cell that is the max of a row. This max cell is in a row below the
row of the other value I want. I know that isn't the best wording, so
I've attached an example. Any help would be greatly appreciated.

Thanks,

Mark


--
Mark444
------------------------------------------------------------------------
Mark444's Profile: http://www.excelforum.com/member.php...o&userid=31378
View this thread: http://www.excelforum.com/showthread...hreadid=510729

Lookup when values located in a row across bottom of table of data
 

Here is the example.


+-------------------------------------------------------------------+
|Filename: Doc1.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4343 |
+-------------------------------------------------------------------+

--
Mark444
------------------------------------------------------------------------
Mark444's Profile: http://www.excelforum.com/member.php...o&userid=31378
View this thread: http://www.excelforum.com/showthread...hreadid=510729