Is there any formula in Excel that works like "vlookup", but reads right to
left?

I know there are workarounds for this (namely, repeating columns), but I
encounter this more than I'd think and it would be nice to have a better
solution. Using Excel 2003.

Thanks!

Chris