I am looking for a way to pair a V-Lookup function with a dynamic range of sheets. I have a payroll document that is supposed to average the overtime for the employees over a month, but having a worker leave or be hired requires change to the formula and we are looking for a way to automatically change the value based on the data we enter into our weekly sheet. I have attached a photo with names hidden so that you guys can see what I am talking about, but anywhere to start working on this would be extremely appreciated.
Thank you,
-Matthew
Bookmarks