Which formula will extract the discount for

Teamer even if other users were to insert rows

or columns into the worksheet?

$=$ VLOOKUP$($B$5,$B$2$:G$3,$ROWS$($B$2$:B$3),$FALSE$)$

$=$HLOOKUP$($B$5,$B$2$:G$3,$COLUMNS$($B$5$:C$5))$

$=x\frac{L}{O}O$ KUP$(B3,B2$:$B3,C2$:$G3)$

$=$ SUMIF$($C$2$:G$2,$B$5,$C$3$:G$3)$