I do not understand - I think I need to nest Match inside a Hlookup formula but not sure how? Question is from NP_EX19_EOM7-1_FirstLastName_1.xlsx. instructions. New Perspectives Excel 2019 | Module 7: End of Module Project 1:

In the Call Type column, she needs to list the type of call corresponding to the code in the Call Code column. In cell E5, 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 2 of the CallTypes table (range A3:F4 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.