Search and lookup functions
Instead of using:
=VLOOKUP(A1, ...etc
you can use:
=VLOOKUP(RIGHT(A1,3), ...etc
Hope this helps.
Pete
On Jan 23, 4:12*pm, bmac wrote:
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
|