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$[[4,$A$],[1,$Code list$],[2,$ID$584747],[3,$CN$04341],[4,$DE$85478],[5,$PW$12345],[6,$UJ$14578],[7,$DEP$4287],[8,$EX$15483],[9,$WS$12347],[10,$WZ$14757]]$

B

$\backslash$table$[[$C$,$D$],[$Lookup codes,Lookup result$],[$ID$584747,],[$PW$12345,],[$CP$12487,],[$HJ$12458,],[$CG$12452,],[$MR$12458,],[$WZ$14757,],[$WR$12458,],[$BC$12579,]]$

$=H\frac{L}{O}O$ KUP$(C2,A$$$2$:$A$$$10,1,$TRUE$)$

$=V\frac{L}{O}O$ KUP$(C^{}2,A$$$2$:$A$$$10,1,$FALSE$)$