Lookup / return latest date in range AND value of 1 column to the

[wellan]

Hello!

I have a range of dates in a single row. Every other cell in the row is a
date, with the remaining alternating cells in the row being revision #'s for
that date (formatted as a 1 or 2 digit numeric and an alpha. e.g. 8C or
13A). Starting with revision #, then date, revision #, date, etc. The first
couple of columns in the worksheet are for the latest revision and it's date
for the record in that row, with many entries down the length of the row.

I discovered how to return the latest date with =MAX(B10:Y10). Now what I
need to do is this; where that date occurs in the row, I need to also grab
the revision number which is always 1 column to the left of that date. I
haven't found any way to do this.

Help!? THANKS SO MUCH!

 

[Toppers]

try:

=INDEX(B10:Y10,0,MATCH(MAX(B10:Y10),B10:Y10,0)-1)

 

[Joel]

match will tell you the relative posigion of the maximum data.
Offset will get the data from that cell
=OFFSET(B10,0,MATCH(MAX(B10:X10),B10:X10,0),1,1)

 

[wellan]

Excellent. Exactly what I needed. Much appreciated!!