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,$