Lookup ? to find name in cell

[Neil]

Hi!

I need to lookup a name in a range and return the value of the cell to the
left of the found name.
I can do it if there is only one name in the cell but not if there is two or
more names in the cell seperated by hypens.
The workbook with the zones and names is also used by other workbooks and is
needed in that format.
for example.

Column A Column B
Zones Names
C1A Rob Logie
C1B Peter Fonti - Fred Thorp - Noel Bell
C1C Ernie Bondoc - Doug Ford
C1D Ernir Grosas - Noel Smith - Tony Smith

The name I am looking for is in one workbook and the list of names and zones
is in another.
I need to find say Fred Thorp and return C1B.
Can this be done and if so can it be done with a closed workbook.

 

[BrianB]

When you use Find there is an option in the dialog box to "Find entire
cells only" - click make the check box blank.

Regards
BrianB
===================================================================