We can use the control’s autocomplete behavior to match categories, but as yet we don’t know the matching category’s unit price—that’s next. How to use the VLOOKUP () function ...

Press the Enter key. The formula runs, using both functions. With this example, the formula finds a product code in the array. VLOOKUP finds the inventory code associated with the product.

For example, if your vlookup statement is something like =vlookup (A1,C:AA,20,FALSE) try to recreate the lookup ttable so it's only 2 columns wide (=vlookup (A1,B:C,2,FALSE) so the extra columns ...