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

SOC Compliance

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!

Andrée Starå

Hi @SOC Compliance

I hope you're well and safe!

Yes, if you select the column(s) as the range, it will be updated automatically for new rows.

Make sense?

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!