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?