Question: been entering support call data. In the Call Type column, she needs to list the type of call corresponding to the code in the Call
been entering support call data. In the Call Type column, she needs to list the type of call corresponding to the code in the Call Code column. In cell E enter a formula using the HLOOKUP function to look up the call type according to the call code. Use a structured reference to look up the value in the Call Code column of the Calls table. Retrieve the value in row of the CallTypes table range A:F in the Survey Questions worksheet using a structured reference to the entire CallTypes table. Because each call type covers a range of values, find an approximate match. Fill the formula into the range E:E if necessary.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
