vlookup looks for the lookup value in the left most column of the table
array. Is it possible for it to look for the value in the right most column
of the table and return a value from a column to the left?

This is backwards from the vlookup statement - I realize. I can't tranpose
the columns in the table array because they needed to stay formatted in this
particular way.