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

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?



Jo Davis wrote:

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

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" wrote:

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?



Jo Davis wrote:

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

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.

Jo Davis wrote:

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" wrote:

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?



Jo Davis wrote:

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


--

Dave Peterson