Vlookup with 2 pick lists and data to be displayed in a chart

[DarrenK]

Not certain how to ask for it. But I'm looking to setup a spreadsheet so that an employee name is chosen from a data validation list (in B7) along with a particular metric header (in C7) - for instance, 'Break Time' is one of the items in the metric list. Once those 2 items are chosen, I have other worksheets named by their date (11-11, 11-12, 11-13, etc). I would like to vlookup the data in the appropriate column (in this case, 'Break Time' - which happens to be column S) within the appropriate worksheet. And then display it along Row 3 so that the latest 10 days worth of values will display using a revolving date.

For example: (B7) John Smith / (C7) Lunch Time is chosen. D3 will display the 10th oldest date lunch time taken. And so on and so on until D3:M3 have data from the latest 10 business days. Then, the data from D3:M3 will be used to display a chart in Row 10. Probably either a line/bar graph. Either is fine. And then the chart would automatically update if a different agent name or metric title was chosen.

 

[DarrenK]

=VLOOKUP(B7,'11-18'!B:V,MATCH(C7,'11-18'!1:1,0),TRUE)

OK So this is what I have so far and it's not working accurately. B7 is the data validation list of reps. '11-18' is the particular sheet I'm pulling data from. B:V is the range within '11-18' that I am searching for rep name (B actually is the column in which the reps' names appear.

For my MATCH formula, C7 is the cell next to the rep name which shows the metric itself (Break, Lunch, etc). I am searching for it within sheet '11-18' row 1 which are the headers. It doesn't appear to be pulling up the correct information. It is retrieving data but from the wrong columns.

Also, is there a way to add something in the formula so that it auto cycles the last 10 business days?