If Then statement returning cell contents

[FireBott]

I am trying to work an If Then formula that will return the contents of a cell. F78 = locations the Dr can practice (this is mult-select), C78 = Name of Doctor, C56 = location name. What I need is if the location is listed in F78 to populate the Doctors name. For example the location list has 3 different locations (Annex, Main and Union). The Doctor can see patients at Union.

If F78 = C56 then list the name from C78.

In this example if F78 has Union (C56) then populate the Doctor name (Cell C78) (Dr. Smith).

I came up with this formula but it is not working =IF(F78=C56,C78)

Thanks for any help.

 

[AlanY]

in what way it isn't working?

Excel 2013/2016
	A	B	C	D	E	F	G
55
56			Loc1
57
77
78			Doc2			Loc1
79
80
81
82			Doc2
83
Sheet2

Cell Formulas
Range	Formula
C82	=IF(F78=C56,C78,"")

Excel 2013/2016
	A	B	C	D	E	F	G
55
56			Loc1
57
77
78			Doc2			Loc3
79
80
81
82
83
84
Sheet2

Cell Formulas
Range	Formula
C82	=IF(F78=C56,C78,"")

 

[ShNBl84]

Do you mean the contents of C56 = "Annex, Main and Union"?

 

[Special-K99]

Does this work?

=IF(ISNUMBER(SEARCH(C56,F78)),C78,"")

 

[FireBott]

The last one worked. Thanks Special-K99