Is There Anyway to Do the Equivalent to VLOOKUP in Excel?

[mrpasini]

Just expanded on this solution with one that includes month names, abbreviations and numeric representations:

Abbreviations: States, Months Macro

This macro can change a state name into one of two standard abbreviations (Associated Press or Postal) and back to the full state name. It can also change a month's name to its abbreviation or numeric representation (and back again). It uses the F2 key for the full name, Control-F2 for the AP or standard abbreviations and Option-F2 for the Postal abbreviation and numeric representations. To use it, just select the name or abbreviation and press the hot key trigger for the result you want. Ab…