Look up the last cell in a column
On Jul 17, 6:54 am, BAKERSMAN
wrote:
Okay, I figured out how to lookup the last numerical value, how can i lookup
the last alpha numeric value?
"Toppers" wrote:
=LOOKUP(99^99,G:G)
will get the last NUMBERIC value in column G.
Does this help?
"BAKERSMAN" wrote:
I am transfering a value in one cell to another worksheet. I need it to pull
the last cell in that column with data in it. The sheet that I need to pull
from is a living document and changes daily. Can someone help?
=LOOKUP(REPT("z",255),[Testme.xls]Sheet1!$G:$G)
Ken Johnson
|