VLOOKUP # of Row/Range

I created a cross-sheet VLOOKUP that will update status from one sheet to the next. The functionality works but the issue I cannot resolve is, on the reference sheet, I want the VLOOKUP to always review the first 500 rows of data.

I can't find where I'd be able to direct it to always review 500 rows. It seems to truncate down to the visible data and requires a manual reference update to include more.

How can I set it up to automatically review 500 rows or better yet, how can I set it up to dynamically adjust and review any and all lines with data in them?

Thank you for your help.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!