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..
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: