View Single Post
  #1   Report Post  
Jo Davis
 
Posts: n/a
Default 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