troubleshooting Question
Excel - Vlookup Name Return Value
asked on
The attached workbook has a worksheet named "Info". We need to look up the Agent on this worksheet, column A, on the DATA worksheet and return:
1. Errors by agent in DATA/A1:A21 to Info/L2:L9, (highlighted in red), without losing the data if someone sorts by agent or any data in either chart.
2. Coaching by agent in DATA/A25:A33 to Info/N2:N9, (highlighted in red), without losing the data if someone sorts by agent or any data in either chart.
*if possible, we would like all charts to sort from smallest to largest automatically.
NOTE: Information is entered into the "RAW DATA" worksheet and pulled into the "DATA" worksheet. From there the "CHART" and "Info" worksheets pull info from the "DATA" worksheet.
CCS-Central-Error-and-Coaching-Octo.xlsx
1. Errors by agent in DATA/A1:A21 to Info/L2:L9, (highlighted in red), without losing the data if someone sorts by agent or any data in either chart.
2. Coaching by agent in DATA/A25:A33 to Info/N2:N9, (highlighted in red), without losing the data if someone sorts by agent or any data in either chart.
*if possible, we would like all charts to sort from smallest to largest automatically.
NOTE: Information is entered into the "RAW DATA" worksheet and pulled into the "DATA" worksheet. From there the "CHART" and "Info" worksheets pull info from the "DATA" worksheet.
CCS-Central-Error-and-Coaching-Octo.xlsx
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.