Too large a table array

[MRomanow]

I am trying to do a VLOOKUP and the data set in the table array appears to be too large to pull the data I need.

I have 2624 customer records in a worksheet and another worksheet (Main) with various information in it. Using the customer code from the Main worksheet I want to pull in the customer's contact information.

It is not working though. I have reformated everything so it matches and this still doesn't help.

Any ideas?