LOOKUP
 

Range is:
A1:K20 with numbers in the columns
I need a lookup that would return the highest non-blank value in a specified
column. A2,A1:K20,Highest Nonblank,

Thanks for any insight, GWB



i.e.
Jan Feb Mar etc
1990 456 34 34
1991 43 6
1992 12 11
etc

Why not just use the MAX function or am I missing something?

"George W. Barrowcliff" wrote:

Range is:
A1:K20 with numbers in the columns
I need a lookup that would return the highest non-blank value in a specified
column. A2,A1:K20,Highest Nonblank,

Thanks for any insight, GWB



i.e.
Jan Feb Mar etc
1990 456 34 34
1991 43 6
1992 12 11
etc