Mark Dvorkin

Posts: n/a

How to LOOKUP the last value in a column on another worksheet?

Hello all,

I can get the last value in column F by using
LOOKUP(9.99999999999999E+307,F:F) on the same sheet
but have no success in geting this value from another sheet.

Thanks in advance for your help,
/mark

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookup cell value using list of worksheet names	amaranth	Excel Worksheet Functions	5	August 8th 05 04:59 PM
match and count words	David	Excel Worksheet Functions	5	July 4th 05 02:24 AM
Lookup values in a column and display them in order with no gaps	Snaggle22	Excel Worksheet Functions	1	April 12th 05 11:36 PM
Lookup then Match and insert value from next column	Tenacity	Excel Worksheet Functions	3	March 4th 05 02:49 AM
grand total column B from every worksheet in workbook	igor	Excel Discussion (Misc queries)	2	February 23rd 05 08:42 PM

All times are GMT +1. The time now is 07:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us