VLOOKUP and HLOOKUP are both used to locate and retrieve ... and the 0 tells Excel to perform an exact match. In this example ...