In cell G32 (Inventory Audit Worksheet), create a VLOOKUP formula for the value in cell B32 from the range A19:M38 on the Inventory worksheet in the seventh column with an exact match. Select range D32:G32, and then copy the formulas through cell range D33:G51.

K10 X D F G H K L M N O P Q R S T V Projection Actual 0 5 0 15 6 6 0 B 1 Category Massage 2 Category Item 3 1 A9 4 2 A10 5 3 A11 6 4 A12 7 5 8 6 9 7 10 8 11 9 12 10 13 11 14 12 15 13 16 14 17 15 18 19 20 Categories 21 Massage 22 23 Food 24 Novelty 25 Reading 26 Clothing 27 28 29 30 Item 31 32 A1 33 A2 34 A3 35 A4 36 A5 37 A6 Mon Thur Sat Wed 0 Fri 0 15 Sun 0 0 0 Golf 0 0 Tues 18 0 14 11 4 0 0 0 0 7 6 0 0 0 0 0 14 0 0 6 25 0 0 23 17 0 0 12 0 0 0 Total in Ending Actual Turnover Description Beginning Total out inventory 35 33 48 10 52 101 Max Stock Inventory Discrepancy 25 On Target 20 On Target 15 On Target 10 On Target 30 On Target 30 On Target 0.00% Healthy Trail Mix 0.00% Resort Polo 0.00% Healthy Energy Bar 0.00% Spirits Lifted Through Yoga 0.00% Golf Tees 0.00% Inventory InventoryAudit DailyTransactions # Ready + 100% A B D G H M N 0 P S T U 1 2 3 Food Item Reading Item Projection Projection Projection Projection Projection Projection E Golf Item A16 A17 A18 A19 Clothing Item A2 Massage Item A9 A10 A11 A12 Novelty Item A13 A14 A15 A5 A1 A3 A20 6 A6 4 5 6 A4 5 6 A7 A8 7 29.48 9 10 11 12 13 14 15 16 17 18 Item Description 19 A1 Healthy Trail Mix 20 A2 Resort Polo 21 A3 Healthy Energy Bar 22 A4 Spirits Lifted Through Yoga 23 A5 Golf Tees 24 A6 25 A7 26 A8 27 A9 28 A10 29 A11 30 A12 31 A13 32 A14 33 A15 34 A16 35 A17 36 A18 37 A19 38 A20 Max_On_Hand WholeSell Price Sale Price Category Delivery Time Current Inventory ReOrder_Point RushReOrderPoint Discontinue ReorderStatus Vendor 45 $ 15.99 $21.99 Food 10 23 201 10 N Ok Vendor 1 350 $ $ 45.34 Clothing 14 15 17 10 N Reorder Vendor 25 $ 3.90 $ 9.95 Food 5 15 10 N Rush Vendor 1 15 $ 6.90 $ 14.95 Reading 7 5 15 10 Y Ok Vendor 4 50 $ 1.30 $ 2.59 Golf 11 27 20 10 N Ok Vendor 5 4 Inventory InventoryAudit Daily Transactions Donde