VLOOKUP not working - plese help.

[hedleyinwa]

I am running a VLOOKUP formula over multiple rows and it is all fine until it gets to the 35th row and after that is produces  #N/A    .   is 34 the limit of how many times you can copy and paste?  I have tried everything and it all keeps ending after 34.  please help.  I have attached the example file here..  

thank you

Frustrated in Seattle.

[#2]

 @hedleyinwa 

Your formula is stopping because it has reached the end of the table array in the VLOOKUP formula, $A$5:$P$38. You must change the table array to include the entire lookup table. In your specific case this would be $A$5:$P$55. The VLOOKUP should be this:

=VLOOKUP($A5,FOOD_DIRECT!$A$5:$P$55,2,FALSE)