Look up the last cell in a column
 

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?

Look up the last cell in a column
 

=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?

Look up the last cell in a column
 

It does a little. This only thing is that I am pulling data from a sheet that
is in a completely different workbook than the one that I am working in.

"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?

Look up the last cell in a column
 

You obviously need to change the workbook/sheet references to any formula
that is given to adapt to your real life situation

=LOOKUP(99^99,[Testme.xls]Sheet1!$G:$G)


--
Regards,

Peo Sjoblom


"BAKERSMAN" wrote in message
...
It does a little. This only thing is that I am pulling data from a sheet
that
is in a completely different workbook than the one that I am working in.

"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?

Look up the last cell in a column
 

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?

Look up the last cell in a column
 

If there are no blank rows in-between

=INDEX(A:A,COUNTA(A:A))

will return last value in A regardless of gender (numerical/text)


=LOOKUP(2,1/(A1:A65535<""),A1:A65535)


will return last value where there can be empty/blank rows in-between


--
Regards,

Peo Sjoblom


"BAKERSMAN" wrote in message
...
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?

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