Jo Davis

Posts: n/a

Lookup Tables with linked sheets

Hi

I have a lookup table that is on a seperate workbook to where the function
is (they are kinked). The lookup will only return results up to row 593. Is
there a limit to the amount of rows you can have in a lookup. It looks in a
named range is it because there is a limit on this??

Please help!!

Cheers
Jo

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 tables	Dave	Excel Worksheet Functions	5	May 8th 05 01:50 AM
Using Multiple LOOKUP tables	KG	Excel Discussion (Misc queries)	3	May 7th 05 01:00 AM
Copying sheets with pivot tables	mnirula	Excel Worksheet Functions	0	March 1st 05 01:47 AM
lookup tables in cells		Excel Worksheet Functions	5	February 28th 05 09:47 AM
Automation of Path of linked tables	S Patel	New Users to Excel	1	February 10th 05 05:53 PM

All times are GMT +1. The time now is 03:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us