What’s a vlookup, you ask? For the uninformed, this fun little Excel command allows you to extract a value based on the position of another value. So, for example, suppose you had a spreadsheet ...

Wouldn’t it be great if you could use this autocompleting feature to search for data? Well, you can. I’ll show you how to combine this behavior in Excel in a combo box with a VLOOKUP () function.

The trick to using Excel's VLOOKUP effectively is knowing what commands and values to use in what order.