Vlookup range not updating with form submissions
I have a sheet with a list of employees that references form responses on a different sheet, and via vlookup function pulls in the date a form was submitted (to track who has submitted the form, and who as not yet done so). The problem I'm having is the vlookup range automatically limits itself to the forms already submitted, even when drag down past submitted rows. So whenever new rows are added I have to manually update the formula to incorporate the new rows. has anyone found workaround for this?
Help Article Resources
Check out the Formula Handbook template!