Excel - INDEX Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need to find an INDEX function that will convert the Call Day (a number 1-7) to the actual weekday found in row 1 of the DayofWeek named range. I don't know if I'm supposed to use the MATCH function as well or not.
Solved by D. D. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 01/10/2018 - 02:24
Hi
User 01/10/2018 - 02:24
Hello
Excelchat Expert 01/10/2018 - 02:24
Welcome to Got it Pro
Excelchat Expert 01/10/2018 - 02:24
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
User 01/10/2018 - 02:24
Alright. That is fine with me.
Excelchat Expert 01/10/2018 - 02:24
Please tell a bit more about the requirement so that i can help better
Excelchat Expert 01/10/2018 - 02:25
Do you have some data and want to show what exactly is required?
User 01/10/2018 - 02:26
Basically I have a table labled "CallDay" and one of the columns is a number 1-7 that represents a day of the week. I have another table labled "DayofWeek" and i need to find an INDEX function that takes the number from the CallDay and shows it as the day of the week the number represents
Excelchat Expert 01/10/2018 - 02:26
okay. Can you share the table and data on spreadsheet on the right
User 01/10/2018 - 02:28
The Weekday column is where I need to input the equation
Excelchat Expert 01/10/2018 - 02:28
You need sunday , monday in that?
User 01/10/2018 - 02:29
Yes I need an equation that will take the number in the Call Day and show it as a day of the week
Excelchat Expert 01/10/2018 - 02:29
which is 1?
Excelchat Expert 01/10/2018 - 02:29
sunday or monday?
User 01/10/2018 - 02:29
1 is Sunday
Excelchat Expert 01/10/2018 - 02:29
Have a look and let me know if that helps
Excelchat Expert 01/10/2018 - 02:30
Did you see?
Excelchat Expert 01/10/2018 - 02:31
Please let me know
User 01/10/2018 - 02:31
It would help but we are supposed to use an INDEX equation since the days of the week are laid out horizontally with no numbers below or beside them.
Excelchat Expert 01/10/2018 - 02:31
Yeah but you can convert it in the form of table that i have just shown and use vlookup
Excelchat Expert 01/10/2018 - 02:32
Populating weekday against a number should not be made that complicated..what do you say?
User 01/10/2018 - 02:33
I think I can make it work.
Excelchat Expert 01/10/2018 - 02:33
Cool
Excelchat Expert 01/10/2018 - 02:33
Please do give good rating and reviews, it really helps
Excelchat Expert 01/10/2018 - 02:33
Have a great day
Excelchat Expert 01/10/2018 - 02:33
Take Care
Excelchat Expert 01/10/2018 - 02:33
I hope this session has been useful for you
User 01/10/2018 - 02:34
Thank you. You too
Excelchat Expert 01/10/2018 - 02:34
Thanks
Excelchat Expert 01/10/2018 - 02:34
You can end the session to provide your ratings

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.