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.