Pulling info from another sheet using pre-defined row and column labels/inputs
Looking for a formula and stuck. Not sure if vlookup, match, index, or a crazy combination of each.
I have a metrics sheet where I want to pull in the number of hours from a another sheet. The source sheet I need to pull from has hours for each month listed (2nd screenshot). However, the source sheet has 3 sets of hours for each month based (different columns, standard, OT, etc).
Now, my metrics sheet has "labels" for the month and the columns that will be used in the formula (1st screenshot). I want this in order to manually change the labels at will and still search the source sheet to pickup the proper number of hours.
How in the world to I write a formula for this?
Help Article Resources
Check out the Formula Handbook template!