Avatar of Jeremy Gilmore
Jeremy Gilmore
Flag for United States of America

asked on 

Excel - Vlookup Name Return Value

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
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
OddyWriter

8/22/2022 - Mon