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.
Parsons, June Jamrich; Oja, Dan; Carey, Patrick; DesJardins, Carol. New Perspectives Microsoft Office 365 & Excel 2016: Comprehensive (Page EX 528). Cengage Learning. Kindle Edition.
