If Function with Strucutred References

[David199]

I'm trying to create a simple table to be referenced by an IF function.

I want to create a single column table of hotel names (i.e. Marriott, Doubletree, etc) and then write an excel formula that says IF(cell reference=a name in the table,"HOTEL","").

In other words, I would like my logical test for the IF function to have many correct outcomes, not just one. I want the IF function to search for an match in the entire table, not a single cell. Is that possible?

 

[jtakw]

Hi,

Use COUNTIF

If you need help setting the formula, please give more description of what you want the formula to do, and what results you want.

 

[Scott Huish]

It sounds like you are doing something like this:

Excel 2010
	A	B	C	D
1	Hotel Names
2	Marriot		Doubletree	HOTEL
3	Doubletree		Not a hotel
4	Motel 6
Sheet1

Cell Formulas
Range	Formula
D2	=IF(COUNTIF(A:A,C2),"HOTEL","")
D3	=IF(COUNTIF(A:A,C3),"HOTEL","")