The VLOOKUP formula consists of four main parts, each of which refers to a piece of information in your spreadsheet:[1] Lookup Value - The cell across from which the data that you want to look up is in. For example, if you want to look up data in cell F3, your lookup value will...