Using a VLOOKUP statement to automatically fill in values.

PROBLEM

Sho$-$Biz Novelty Company needs to create LOOKUPs to automatically fill in Item DESCRIPTIONS and LOCATIONS from a separate INVENTORY list. Since its Inventory List is vertical $($with headings in columns and unique item #s$)$ a VLOOKUP is appropriate set to require an exact match.

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Create VLOOKUP functions with appropriate cell references as indicated.

$\backslash$table$[[1-1$