One way:

=INDEX(B12:B407,MAX(IF(E12:E4070.9,ROW(E12:E407)-MIN(ROW
(E12:E407))+1)))

Array-entered, meaning press ctrl + shift + enter. To
learn more about array formulas, see:

http://www.cpearson.com/excel/array.htm

HTH
Jason
Atlanta, GA

-----Original Message-----
Column B has dates, 1 Jan 05 through 31 Jan 06. Column E
has numbers .1,.2,
up through 6. I need a lookup function that will find
the last value in
column E that is greater than .9 and then display the
date in same row from
column B. This will be on a summary sheet and have a
lookup function for each
of the sheets that follow. I had this but could not
figure out how to use .9
and the make the formula on another sheet. "=LOOKUP
(6,E12:E407,B12:B407)". I
want the 6 to be a .9 instead.
Help! Thanks Jim
.