**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.*