Which of the formulas below would not work to show $2024$ in cell D$3?$Which formula will extract the discount for Teamer even if other users were to insert rows or columns into the

worksheet?

$=$XLOOKUP$($B$3,$B$2$:B$3,$C$2$:G$3)$

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

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

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

$=$EDATE$(B3,12)$

$=$ EOMONTH$($B$3,11)$

$=$YEAR$(B3)$

$=B3$