Vlookup

[Cazumel]

I have the following situation:

Look up M1459 on R1459 how do I build my look up reference matching only the
numbers and not the letters.

Thank you

 

[Max]

Produce a new "rightmost" col to serve as the vlookup's col which contains
the stripped text nums, eg:
In C2, copied down: =RIGHT(B2,4)
where B2 down house the references eg: R1459, etc

Then you could use something like this:
=VLOOKUP(RIGHT(A2,4),C:E,2,0)
where A2 down contains the lookup values, eg: M1459

Above presumes data as you posted is representative
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik