Question $6$

$1$

Point

vlookup.jpg

Imagine we want to calculate CURRENT YEAR's Quantity. It is based on LAST YEAR's Quantity and an increase amount based on the RATING and POLICY TABLE.

Which VLOOKUP formula would give us the CURRENT YEAR's quantity in cell D$6?$

$=$ VLOOKUP $($ C$6,$ $G$$6$:$I$$10,2)*$ B$6$

$=$ VLOOKUP $($ C$6,$ $G$$6$:$I$$10,2)*$ B$6+$ B$6$

$=$ VLOOKUP $($ C$6,$ $G$$6$:$I$$10,2)+$ B$6$

VLOOKUP $($ C$6,$ $G$$6$:$I$$10,2)*$ B$6+$ B$6$

$=$ VLOOKUP $($ G$6,$ C$6$:I$10,2)*$ B$6+$ B$6$