Try it as you said it

=VLOOKUP(RIGHT(A16,2),A8:E8,5,FALSE)


--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"rudy" wrote in message
...

I have been trying to use the RIGHT function in a VLOOKUP and can not
get it to work. For example if my VLOOKUP is

=VLOOKUP(A16,A8:E8,5,FALSE)

In the range I am looking at I only want to look at the right 2
characters in column A.

If cell A8 is M200612 I only want to look for the 12.

Does anyone know how to do this???

Thanks.


--
rudy
------------------------------------------------------------------------
rudy's Profile:
http://www.excelforum.com/member.php...o&userid=33911
View this thread: http://www.excelforum.com/showthread...hreadid=545574