In the shipping cell (H29), enter a formula that nests the VLOOKUP function in an IF function to look up the shipping cost from the Shipping Cost table in the Pricing and Shipping worksheet based on th subtotal in cell H27. If the subtotal is 0, the shipping cost should display 0. (Hint used the defined name you created for the Shipping Cost table data.)

- I am completely stumped on this question please help!

Home Insert Fage Layout ormulas Data Revie Foxit PDF Tell me what you wantto do AutoSumA Wrap Tex Consolas 11 A A General copy , Paste 1 u . . 2-. $. %, Conditional Format as Cel Inser. Delete Format Formatting Table StylesT Merge & Center- Format Pairter ClearFilte Clipboard Font Alignment Numbe Styles Cells Eciting H29 9 Sold to 10 Lauri Bradford 226 South Street 1 Havwtiorne HV 89415 tem Flavor Price Total 1 Gourme 17 13 19 20 21 Nacho Cheese n tin 1 $ 5.00$ 5.00 23 25 27 Notes: Subto:al5.00 Sales Tax 034