OR: The problem with VLOOKUP. Wikipedia gives us a table of birthstones, and I think just because it’s Wikipedia, there’s a trailing space after every entry. Pasted into a spreadsheet, the table looks like this:
A
B
C
D
E 1
Month
Traditional Birthstone(s)
Modern Birthstone(s)
Mystical Birthstone
Ayurvedic Birthstone 2
January
Garnet
Garnet
Emerald
Garnet 3
February
Amethyst
Amethyst
Bloodstone
Amethyst
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/09/10/left-looking-lookups/
Posted
Sep 10 2010, 12:28 PM
by
Daily Dose of Excel