Question $7$ of $10$

Question: Identify the formula that is used to cross$-$reference the lookup code ID$584747,$ in cell C$2,$ to find exact matches in the code list in column A$,$ in a worksheet in Excel $365.$

Instruction: Choose the option that best answers the question.

$\backslash$table$[[$A$,$A$,$B$,$C$,$D$],[1,$Code list,,Lookup codes,Lookup result$],[2.,$ID$584747,,$ID$584747,],[3,$CN$04341,,$PW$12345,],[4,$DE$85478,,$CP$12487,],[5,$PW$12345,,$HJ$12458,],[6,$UJ$14578,,$CG$12452,],[7,$DEP$4287,,$MR$12458,],[8,$EX$15483,,$WZ$14757,],[9,$WS $12347,,$WR$12458,3],[10,$WZ$14757,,$BC$12579,]]$