In cell J10, enter an INDEX function that will convert the Call Day to the actua

Question

In cell J10, enter an INDEX function that will convert the Call Day to the actual weekday found in row 1 of the DayofWeek named range. Resize the column width as needed

this is the same as this question:

http://www.chegg.com/homework-help/questions-and-answers/cell-j10-enter-index-function-convert-call-day-actual-weekday-found-row-1-dayofweek-named--q24797028

"In cell J10, enter an INDEX function that will convert the Call Day to the actual weekday found in row 1 of the DayofWeek named range (located on another Sheet) Not really sure how to go about this at all. I need make the number of the day converted into the actual names of the days of the week, referencing the DayofWeek range

This is for an excel assignment."  

**Not sure that i should be using the match function

Dayofweek Jr Sunday Human Department 2 Public Affairs 3 Human Resources 4 Admissions 5 Accounting 6 Public AffairsResources Frozen screenBlackboard Voicemail Other Admissions Banner Intranet Blackboard Financial Aic Internet Blackboard Intranet Internet Accounting Blackboard Internet Electrical Internet Intranet 2 Financial Aid 8 Sunday Tuesday Friday Saturday Day of Week 10 Financial Aid Monday Wednesday Thursday

Explanation / Answer

You do not need to MATCH as the nested function inside the INDEX function.

INDEX function is enough to fetch the day as per index of Call day.

The exact formula to be used is:

=INDEX(DayofWeek,1,Call_day)

This function will fetch the day of week from row 1 and column corresponding to the call_day from the DayofWeek table.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.