Excel’s autocomplete feature works with data input ... combo box, matching categories to the letter B is easy. To get the unit price, we’ll link the combo box to a VLOOKUP() function.

SEE: 83 Excel tips ... a dialog box and waits for the user to enter content and then click a button to continue. This function usually stores a String that contains the input value that you ...