Sheet 1, row A contains the container number I am looking for

Post several representative samples of these.

Sheet 2 row A also contains the container numbers,
although some of these have 2 container numbers
in the same cell.

Post several representative samples of these, also.

--
Biff
Microsoft Excel MVP


"Geeban" wrote in message
...
Hello,

I am trying to look for partial text within a cell. What I am trying to do
is to find a cell that contains specific text from a cell. I am working
from
2 different sheets in the same workbook.
Sheet 1, row A contains the container number I am looking for. Sheet 2 row
A
also contains the container numbers, although some of these have 2
container
numbers in the same cell. Sheet 2, row C contains ETA which is what I
would
like to return.
As some of the cells contain 2 container numbers, I cannot use a vlookup
find either of them. To put it simply, I want to use a lookup from partial
text and return a value on a corresponding row.

Any help is greatly appreciated.