Question

OWN 1 Sporting Goods Inventory List Item Name Preferred Supplier Quantity on Hand Reorder Point Reorder Quantity Cost per Unit Sales Price per Unit Tenacket Sport Spiesne 100 150 S6000 SIKO0 Golf club (driver) GA Sports Distribution 250 150 150 $80.00 $200.00 5 Can of tennis balls GA Sports Distribution 400 250 250 $2.00 $4.00 Basketball Sports Supplies, Inc. 150 100 200 $11.25 $25.00 Football GA Sports Distribution 600 400 300 $12.00 $10.00 Baseball bat IGA Sports Distribution 300 2001 200 $35.00 $100.00 Baseball We Sell Sports 475 300 300 $6.00 $15.00 Soccer ball We Sell Sports | 100 $15.00 $1000 11 Baseball dove We Sell Sports 1000 600 $2000 $50.00 Sports Supplies, Inc Hockey stick 300 275 275 $40.00 $90.00 Total Item S1200000 $20,000.00 $800.00 $1.687.50 $7.200.00 S10.500.00 52,850.00 $1.500.00 $20.000.00 $20.000.00 306 17.50 80 600
please help me write a VLOOKUP formula to find the reorder quantity for the basketball

Answer 1

VLOOKUP FORMULA: =VLOOKUP(A6,A2:H12,5,0)

File View Tell me what you want to do.... Sign in O r General AutoSum A Home Insert Page Layout Formulas Data Review % Cut Calibri - 11 AA = = = Le Copy Format Painter BIU - - A- Clipboard Font - : * fc =VLOOKUP(A6,A2:H12,5,0) * Wrap Text Merge & Center - Paste Ex Insert Delete Format $ -% D D Conditional Format as Cell Formatting Table Styles Styles -08 Clear Sort & Find & Filter Select Editing Alignment Number Cells SUM DE H I J K L 200 |=VLOOKUP(A6,A2:H12,5,0) 1 Sporting Goods Inventory List 2 Item name 3 Tennis racket 4 Golf club (driver) 5 Can of tennis balls 6 Basketball 7 Football 8 Baseball bat 9 Baseball 10 Soccor ball 11 Baseball glove 12 Hockey stick 13 Preferred supplies Sport supplies, Inc. GA Sports Distribution GA Sports Distribution Sport supplies, Inc. GA Sports Distribution GA Sports Distribution We Sell Sports We Sell Sports We Sell Sports Sport supplies, Inc. 150 600 Quantity on Hand Reorder point Reorder Quantity Cost per Unit Sales Price per Unit Total Item 200 100 150 $60.00 $150.00 $12,000.00 250 150 150 $80.00 $200.00 $20,000.00 400 250 250 $2.00 $4.00 $800.00 100 $11.25 $25.00 $1,687.50 400 300 $12.00 $30.00 $7,200.00 300 200 200 $35.00 $100.00 $10,500.00 475 300 $6.00 $15.00 $2,850.00 100 80 120 $15.00 $30.00 $1,500.00 1000 600 $20.00 $50.00 $20,000.00 500 275 275 $40.00 $90.00 $20,000.00 $96,537.50 300 600