search value as part of a cell value
 

I have a question regarding searching in cells for a value, and
returning corresponding data.

_This_is_what_my_workbook_looks_like_:

*Sheet1*, cell *A1* contains value "D600"
*Sheet1*, cell *A2* contains value "V-1234"
*Sheet1*, cell *A3* contains value "DB23"

*Sheet1*, cell *B1* empty
*Sheet1*, cell *B2* empty
*Sheet1*, cell *B3* empty
...

*Sheet2*, cell *B1* contains value "whatever A900"
*Sheet2*, cell *B2* contains value "i was there D600 till then"
*Sheet2*, cell *B3* contains value "ok SSSF, V-1234, whatever"

*Sheet2*, cell *A1* contains value "S0005050"
*Sheet2*, cell *A2* contains value "S0004321"
*Sheet2*, cell *A3* contains value "S0001234"

_This_is_what_i'm_trying_to_accomplish:_

1. search each cell value form Sheet1 column A, in Sheet2 column B
2. when a match is found, return the corresponding value of column A
from Sheet2

So with the above example, the returned value for
Sheet1, cell B1, would be "S0004321"
Sheet1, cell B2, would be "S0001234"
Sheet1, cell B3, would be empty

Actually in a few words, i need nothing more then the vlookup function,
but instead of matching cells on their full cell value, i need to match
on part of the cell value.

I hope i didn't make this to difficult.

Is there somebody who knows a solution? I've been searching the net
but i couldn't find anything that worked out for me.


--
Nogi
------------------------------------------------------------------------
Nogi's Profile: http://www.excelforum.com/member.php...o&userid=22189
View this thread: http://www.excelforum.com/showthread...hreadid=553939