I wonder if I can do a vlookup where the index_num is to the left (not right) of the first entry of the table array. Example:
A B
car 1
cat 2
dog 3
bird 4

I want to do =vlookup so that I search for "1" and it will yield "car". Currently, I always have to move the output to the right side of the lookup. It annoys me to have to do this all the time.