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.
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
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
Who is Participating?
This is your example.
CCS-Central-Error-and-Coaching-Octo.xlsx
CCS-Central-Error-and-Coaching-Octo.xlsx
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.
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,
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,
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.
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. 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.