Hi everyone,

I have a question about how to extend the use of my vlookup-formula.

I have a table with different values like this:

C1:4001T, SEBA
C2:T4001
C3:5820S
C4:ALBT, 5820, BTAL

I need to match the numbers (4001, 5820) with another table, but so far I
haven't found the solution. I've tried to format the values to lookop only
the four last numbers or the four first number. That will do for the three
top examples. But for my last example, I'm not able to match 5820 with my
other table.

Is it possible to adjust the vlookup-formula to search for content in a
cell, rather than the value of it? Or is there another formula to use in this
case.

Thanks:)

Traima