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
Jeremy GilmoreAsked:
Who is Participating?
 
OddyWriterConnect With a Mentor Mr.Commented:
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.

Solution:
1. Define name A12:B22 (Sheet:Data) as "ErrorbyAgent"
2. Sheet: Info
2.1 Edit the name (A2:A9) to corrected info (Same as A13:A21 in Sheet:Data) eg "Alex" or "Alexandra", "Devon   " or "Devon".
2.2 input "=VLOOKUP(A2,ErrorbyAgent,2,FALSE)" in L2.

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.

Solution: Same scenario with above.
0
 
Jeremy GilmoreAuthor Commented:
It comes out as "#NAME?". I tried "_" between the words and capitalized them.
0
 
OddyWriterMr.Commented:
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
Jeremy GilmoreAuthor Commented:
Can you tell me what you did? I just copied the formula over to the coaching column, change ErrorsbyAgent to CoachingbyAgent and it gives me the #NAME? invalid name error.
0
 
OddyWriterMr.Commented:
1. Did you create the Name : CoachingbyAgent?

Please follow the steps:
1. Define name A12:B22 (Sheet:Data) as "ErrorbyAgent"
2. Sheet: Info
2.1 Edit the name (A2:A9) to corrected info (Same as A13:A21 in Sheet:Data) eg "Alex" or "Alexandra", "Devon   " or "Devon".
2.2 input "=VLOOKUP(A2,ErrorbyAgent,2,FALSE)" in L2.
0
 
Jeremy GilmoreAuthor Commented:
Got it thank you very much!
0
 
OddyWriterMr.Commented:
Got thanks from questioner.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.