Try this:

=VLOOKUP(TRIM(MID(SUBSTITUTE(A1,"/",REPT(" ",99)),198,99))+0,$B$1:$C$4,2,0)


"starfishgooner" wrote:

Hi Can anybody help?? I am trying to lookup a numeric value amonsgt text in
a colunm, match this numeric value exactly in another column and then return
a value from a third column to a new column. For example:

column 1, cell 1
'corr/joebloggs/445544/transfer'

I want to find the '445544' sitting in column 2, then return a value (say
12345) sitting in column 3 to a new column, 4

Its confusing me just writing this!!! Please help!!