-Each instrument will either be sold, donated, or thrown away based on the slling price. In cell A12, enter the label What To Do Table and format it as as bold. Starting in cell A13, create a VLOOKUP table based on the following criteria

Sale Price What To Do

under $100 Throw Away

$100 - $499 Donate

$500 and above Sell

-In Column E, enter the label What To Do and format the label as bold. Enter formulas that use the VLOOKUP function to display what to to do with each instrument

MUSIC SALE- Saved to OneDrive Autosave Formulas Data Review View Help Tell me what you want to do File Home Insert Draw Page Layout Define Name Use in Formula Create from Selection Trace Precedent Trace Dependen Remove Arrows Name Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time* Reference* Trig Functions Manager Function Defined Names Function Library A13 1Used Equipment Inventory 3 Instrument 4 Piano 5 Saxophone 6 Drums 7 Electric Guitar 8 Flute 9 Violin 10 Original Price $2,500 $275 $789 Condition Selling Price $1,500 $110 20% $157.80 30% $136.80 $245 $345 12 13 16 18 19