Question: 5 The value returned in cell 1 9 is a whole number. You want to display the weekday equivalent. In cell J 9 , insert

5 The value returned in cell 19 is a whole number. You want to display the weekday equivalent.
In cell J9, insert a VLOOKUP function to look up the value stored in cell 19, compare it to the array in the range H2*16, and return the day of the week. Use mixed references to the table array. Copy the function from cell Jg to the range J10:J33.
 5 The value returned in cell 19 is a whole number.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!