Question

In Excel, if a code for a book is in cell C5 and we want to find that code and display the title of the book from column B of the data set (BookData), the following VLOOKUP could be used:

=VLOOKUP(C5, BookData, B, True)
Group of answer choices
A.True
B.False

Answer 1

B. False.

Step-by-step explanation:

The correct formula would be:

3=VLOOKUP(C5, BookData, 2, False)

This formula searches for the value in cell C5 in the first column of the BookData range and returns the value in the second column of the same range, which in this case is the title of the book. The fourth argument of the VLOOKUP function should be set to False to ensure an exact match.