Mohamed,
VLOOKUP requires a table and doesn't seem to work on the text fields I'm
working with. Unless my understanding is off.
-J

"Mohamed Shafiee" wrote in message
...
Hi,

It is vlookup.... Use vlookup function.

=vlookup(A1, B:C, 2)

Shafiee.

"JayL" wrote in message
...
All,
Looking for code to read contents of cell A1, search column C for any
cell
that contains A1 anywhere in a cell and return the row number of any
finds
in Column C to cell B1.
I used the match function and it works but has a 255 character cell
limitation, which I need to surpass.

TIA,
J