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