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