VLOOKUP ERROR

Hello,

I wanted to use VLOOKUP for referencing cells within the same sheet. But it only works for certain range:

  1. Range 1: 19 Columns x 3800 Rows -> This work
  2. Range 2: 19 Columns x 3900 -> This doesn't work. Gives "#NO MATCH" error.

Could you please suggest what what to do?

Best Regards,

Adarsh

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!