I love choose. I had a choose choose between seven chooses once, each of which was a vlookup. It was fun.
Here, this should keep you going until 2039, if you find out for sure the letter indicates decade. You can vlookup an array right in the formula so you don't have to worry about placing a little table somewhere to vlookup against. Works well for small tables.
If you put a { at the start, every time you enter a , excel reads it as next column within the row, but when you use a ; excel reads it as next row
So, this would be a three by three table (I put cell references in there to visualize it but you can have any value. )
Bookmarks