Do you mean something like

=INDEX('Sheet B'!$A$1:$A$1000,MATCH(MAX('Sheet A'!B1:B200),'Sheet
B'!$B$1:$B$1000,0))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Brisbane Rob"
wrote in message
news:Brisbane.Rob.2250tn_1138103703.8544@excelforu m-nospam.com...

Hi Bob

The date is used to get the data from a corresponding date in another
spreadsheet. i.e. 1/20/06 will get a value from spreadsheet B which
also has dates for the month.

Thanks


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile:
http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=504327