To get the unit price, we’ll link the combo box to a VLOOKUP () function. As you enter characters, the VLOOKUP () function will return the currently matched category’s unit price.

CSV files create columns of data from a variety of sources, such as address books and GPS location lists, and VLOOKUP enables your business to analyze these sources.