$\frac{0}{8}$CFI.

Exams $|$ Fundamentals of Data Analysis in Excel

Exit Exam

$14$ out of $15$

Review Later

Looking Up Data $-$ VLOOKUP$()$

What is important to remember about the lookup table to ensure that the VLOOKUP$()$ function calculates as expected?

The lookup table needs to be sorted.

The lookup table can only be used to return an approximate match.

The lookup table needs to contain all of the possible values of the source table.

The lookup table needs to be the same size as the source table.