which-of-the-following-statement-is-correct-about

Which of the following statement is correct about the VLOOKUP formula