Using VLOOKUP

You have a table ‘Books’ as given below.

What will be the result of running the following function on the table?

VLOOKUP(“Chemical Principles”, A2:B6, 2, FALSE)

Options
  • The price of the first occurence of “Chemical Principles”
  • The price of the second occurence of “Chemical Principles”
  • #N/A
  • None of these

Related Posts