Only For Knitters and Excel Users (Geeks)
Okay, my blog almost always has at least something for fiber artists/crafters/etc.. However, if you don’t use Microsoft Excel, or don’t care about doing vlookup’s, then skip to the bottom of the page for an update on fiber-related things.
VLOOKUP in Microsoft Excel
Do you know what vlookup is? Do you see others doing vlookups and want to use it too? Are you an expert at vlookup, but find the limitations of multi-field comparisons annoying?
For the uninitiated, vlookup is a delivered calculation routine that allows you to look up the value in one spreadsheet and display information about that value from a look-up on another spreadsheet. So, for instance, if you had two spreadsheets, one with a list of people and their address, and another with a list of the state abbreviations and state names:
You could insert a vlookup calculation that would compare the State abbreviation against your list and return the full state name as the result of the calculation…a very simple example, but vlookup can be used from some very powerful uses when you start getting into it.
A couple of problems with vlookup:
- The syntax of the vlookup statement isn’t very intuitive and prone to a lot of mistakes
- Formatting of the lookup field and the lookup table are very persnickety
- Comparing multiple fields in different columns against multiple fields in the lookup table is more effort
- Comparing near-matches doesn’t work very well with vlookup