Click over to the second sheet in the example workbook, where you’ll see names, vehicle makes and models, and the base price, discount, and sale price of each vehicle. Several of these options are self-explanatory, but we’ll take a look at some of the more esoteric options.įirst, let’s see how the Look in menu changes our search. Match entire cell contents tells Excel to only return cells that match your search query exactly, and don’t contain anything else.
Match case makes the search case-sensitive.Look in: tells Excel where to look for your search query (we’ll talk about this in a moment).