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.