Hi Jacob,

If I can expand my example, it may help me and you!! I have:

Col A Col B Col C
Col D
'corr/joebloggs/445544/transfer' 263636 8701111 MATCH COL A&B to
give C
'corr/joebloggs/554455/transfer' 263637 8702222 MATCH COL A&B to
give C
'corr/joebloggs/263636/transfer' 554455 8703333 MATCH COL A&B to
give C
'corr/joebloggs/263637/transfer' 445544 8704444 MATCH COL A&B to
give C

So for the first row, the result in D1 should match A1 with B4 to give
number found in C4.

I do hope you can help.....Thanks very much,

Andy

"Jacob Skaria" wrote:

In cell A1:
corr/joebloggs/445544/transfer

If you mean 445544 in any of the row in column B and a corresponding number
in ColumnC in the same row

In cell D1
=INDEX(C:C,MATCH(LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0 123456789")),ROW($1:$10000)))),B:B,0))

If this post helps click Yes
---------------
Jacob Skaria


"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!!