Forum Discussion

hedleyinwa's avatar
hedleyinwa
Copper Contributor
Aug 18, 2019

VLOOKUP not working - plese help.

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.

 

 

excel
Formulas and Functions

1 Reply

  • brummers's avatar
    brummers
    Copper Contributor
    Aug 18, 2019

     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)

Resources