How to do a Vlookup of Entire Sheet Not Just a selected table range

The question is when we select a specific range for VLookup it just works for that range and when a new row is added it will not work on new rows until or unless we update our Vlookup table range.

is there any method to automatically include new rows within Vlookup table range ?

Please guide, Thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!