Lookup Tables with linked sheets

[Guest]

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

 

[Dave Peterson]

My first bet is your named range isn't what you want it to be. If you look at
Insert|Name|Define and inspect your range name, do you see what you expect?

 

[Guest]

Hi Dave
Thanks for your resonse

Yes the named range is the same, i have decided to use an index match
formula instead now, i am still wondering if there is a limit to how many
rows you have have within a look up.

 

[Dave Peterson]

I don't think so. There may be some long calculation times when you have lots
of rows (and lots of formulas).

But I would bet that =index(match()) suffers the same problem.