How do you do vlookup formulas for the price section?

27 28 Click on the Sample Invoice tab to view its example. To prevent errors, update column B of the 29 sample invoice using a data validation list of Item #s provided in the Inventory tab. Use vlookup 30 to automatically display the description and unit price of the Item # shown. Add appropriate 31 formulas to Price, Subtotal, Sales Tax and Total. A B 1 Wolfie's Flooring Emporium 2 1701 Wright Street 3 Madison, WI 53704 4 Bill To: Sample Customer 5 123 Main Street, Anywhere, WI 53000 6 7 Room Item # Description 8 Living Room C-1005 Lucky One 9 Kitchen F-2210 Laminate - Lifeproof 10 Master Bedroom C-1015 Bellbury 11 Master Bath F-2230 Tile - Natural Stone 12 Bedroom #1 C-1025 Boxton 13 Bedroom #2 C-1030 Bluff 14 15 Address: (608)246-6500 Phone: Contact: Square footage 300 140 225 120 130 130 (555) 555-1212 Ms. Customer Unit Price $3.00 9.75 $4.00 12.75 $5.00 $5.50 F Email us at: Wolfie@WolfiesFlooring.com Website: WolfiesFlooring.com Invoice #: Invoice Date: Price $900.00 1,365.00 900.00 1,530.00 650.00 715.00 27 28 Click on the Sample Invoice tab to view its example. To prevent errors, update column B of the 29 sample invoice using a data validation list of Item #s provided in the Inventory tab. Use vlookup 30 to automatically display the description and unit price of the Item # shown. Add appropriate 31 formulas to Price, Subtotal, Sales Tax and Total. A B 1 Wolfie's Flooring Emporium 2 1701 Wright Street 3 Madison, WI 53704 4 Bill To: Sample Customer 5 123 Main Street, Anywhere, WI 53000 6 7 Room Item # Description 8 Living Room C-1005 Lucky One 9 Kitchen F-2210 Laminate - Lifeproof 10 Master Bedroom C-1015 Bellbury 11 Master Bath F-2230 Tile - Natural Stone 12 Bedroom #1 C-1025 Boxton 13 Bedroom #2 C-1030 Bluff 14 15 Address: (608)246-6500 Phone: Contact: Square footage 300 140 225 120 130 130 (555) 555-1212 Ms. Customer Unit Price $3.00 9.75 $4.00 12.75 $5.00 $5.50 F Email us at: Wolfie@WolfiesFlooring.com Website: WolfiesFlooring.com Invoice #: Invoice Date: Price $900.00 1,365.00 900.00 1,530.00 650.00 715.00