Lookup value problem!!

L

Loanie

I need a function that would help me look up the last type in value of
specifed range and display that value in a cell on a differen
worksheet.
Thanks,
Loani
 
P

Peo Sjoblom

I don't understand the question, what do you mean by that?
Do you mean the last value as in

a
b
c
d
e

where "e" would be the last value?

=OFFSET($A$1,COUNTA(A:A)-1,)

will find the last value in column A assuming there are no blank cells
in-between

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
L

Loanie

Peo,

Thank you sooooo much...that function is what I was looking for. Than
you...you're a genius!!!

Peo, is there a function such as the one you posted that would wor
when there are blank cells in between???

Loani
 
P

Peo Sjoblom

Thanks for the feedback!


Yes, here are some formulas, if you know the last value is numeric you can
use this

=INDEX(A:A,MATCH(9.99999999999999E+307,A:A))

if you know the values are text

=INDEX(A:A,MATCH(REPT("z",255),A:A))

and if it's either text or numbers

=INDEX(A:A,SUMPRODUCT(MAX((A1:A65535<>"")*ROW(1:65535))))


--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
L

Loanie

Peo,

I'm so glad I found this forum...and your feedbacks make me appreciat
this forum even MORE!!! Thank you so much...the functions you poste
help me GREATLY!!!

Sincerely,

Loani
 
Top