Can I do a Vlookup from the right side of an area ?

Instead of just the left?

I have an area called "range". It's about 7 columns wide. The far left column is employee numbers. I want to return the emp. number based on something that is figured in the far right column.....

I know to do one of 2 things:
1)
duplicate the employee # column at the far right
2)
move the column with the determining info to the left of the employee numbers

I dont want to either

Any Clues?
Thank You