Home $>$ Search

Finding and analyzing data with formulas in Excel $365$

Question $2$ of $10$

Question: Identify the formula to find a row reference for the date value in cellic$2$ in the Supplier Orders double$-$entry table. In this case, D$1$:D$22$ references the date range in the source table.

Instruction: Choose the option that best answers the question.

$=$XMATCH$($C$2$'Supplier Orders'!D$1$:D$22)$

$=$XLOOKUP$($C$2$;'Supplier Orders'!D$1$:D$22)$

$=$INDEX$($C$2$;'Supplier Orders'!D$1$:D$22)$