Microsoft Office 365 Office 2016 Intermediate
Excel Module 8: Working with Advanced Functions
Case Problem 4: Create EX527
5. In cell B18, create a formula using nested IF functions and VLOOKUP functions to determine what to do with the returns. Use the lookup table in the Return Data Worksheet. Refer to Figure 8-46 for some hints on how to create the formula.
Solved by A. J. in 22 mins