Here are some problems that our users have asked and received explanations on
nested lookup formulas needed for this table
Solved by I. W. in 23 mins
In cell B3 insert a nested MATCH function within an INDEX function that will look up the rental price in column D using the apartment number referenced in cell B2. With 101 entered in cell B2, the lookup function displays $950.00.
Solved by A. J. in 23 mins
I have a nested LOOKUP formula which is not working
Solved by V. U. in 17 mins
Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific sales record. For example, using the current data, you want the function to return the third quarter sales for Erica.
Solved by X. B. in 19 mins
Enter a nested lookup function in cell F5 that evaluates the Trans # in cell B5 as well as the Category in cell D5, and returns the results based on the data in the range A8:F32.