Formula to lookup value across multiple columns

[claybwagner28]

Hello everyone. I was given a spreadsheet of locations in column B with managers listed in columns C though G depending on how many a location had. I have a separate spreadsheet where I need to list whether the associate is a manager or not. I am thinking INDEX and MATCH but I have never done one. Any ideas or a better solution?
Thanks!

 

[Eric W]

Maybe:

Book1
	A	B	C	D	E	F	G	H	I	J
1		Location	Managers						Associate	Manager?
2		A	Jane	Jack	Jerry				Jack	TRUE
3		B	Joe						Jodie	TRUE
4		C	John	Jill					Mary	FALSE
5		D	Julie	Josephine					Mark	FALSE
6		E	Jessica	Jodie					Jill	TRUE
7
Sheet24

Cell Formulas
Range	Formula
J2:J6	J2	=COUNTIF($C$2:$G6,I2)>0

 

[claybwagner28]

I’ll try it. Thanks!

 

[claybwagner28]

Worked great. Thanks!

 

[Eric W]

Happy to help! Thanks for the update.