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.