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
Check out the Formula Handbook template!