Search and lookup functions

[bmac]

Hello, any help appreciated,

I have values in column A such as 123CRR, 123ABC, 456ZZZ, etc.

I want to have a lookup table that contains
CRR = this
ABC = that
ZZZ = something else

I need a way to extract or identify the specific text string in column A and
then use that value in a lookup table. I know how to use lookup tables when
all I am looking up is the entire value in column A. I am looking for a way
to extract just the text value and then use that in my lookup table.

Thanks very much in advance,
bmac

 

[Pete_UK]

Instead of using:

=VLOOKUP(A1, ...etc

you can use:

=VLOOKUP(RIGHT(A1,3), ...etc

Hope this helps.

Pete