I am absolutely clueless on the formula. I have a sheet titled Agent Lookup. I have other sheet tabs labeled with the date of each report (12-01, 12-02, 12-03, 12-04). In Agent Lookup cell B4 I have a data validation list of all agent names. In C3 I have 12-01, which references the data from that date going across but also references the tab '12-01'. And then C4:Cxx will be the rest of the dates of the month.
In D3:I3, I want to populate the data from each sheet based on the header (Handle Time, Wrap Time, Hold Time, Lunch Time, Break Time, etc).
=VLOOKUP(B4,INDIRECT("'" & $C$3 & "'!"),1,TRUE) I know it's completely incorrect but an having trouble understanding how to reference the other sheets in the formula. I want to take the Handle Time for 12-1 (column K in '12-01' sheet), cross reference the agent's name in 'Agent Lookup' B4, and have it locate data in the cell in column K which corresponds to the row in which the agent name appears.
If Joe Smith's name is in B4, it would pull data from K11 because Joe's name appears in row 11, the data of course being in column K. What am I missing in my formula?
Thank you in advance
In D3:I3, I want to populate the data from each sheet based on the header (Handle Time, Wrap Time, Hold Time, Lunch Time, Break Time, etc).
=VLOOKUP(B4,INDIRECT("'" & $C$3 & "'!"),1,TRUE) I know it's completely incorrect but an having trouble understanding how to reference the other sheets in the formula. I want to take the Handle Time for 12-1 (column K in '12-01' sheet), cross reference the agent's name in 'Agent Lookup' B4, and have it locate data in the cell in column K which corresponds to the row in which the agent name appears.
If Joe Smith's name is in B4, it would pull data from K11 because Joe's name appears in row 11, the data of course being in column K. What am I missing in my formula?
Thank you in advance