Creating a Flag using Multiple Data Tables

[SanFelippo]

This should be pretty simple, but I can't remember exactly how to do it. Basically I have 3 tables with different values. These tables are as follows:

Table 1 (State-County)
17-31
17-32
17-33
17-40
17-50
17-62

Table 2 (Prop Type)
1
2
3

Table 3 (Product)
S30
S20
S10
HR30


I then have a data set that contains a column of data for each table you see above. Basically all I want to do is create a "Yes" "No" flag in the data set will look at the values each particular application has for each of the tables and determine if it fits.

Fro example, this could be done with a very long If statement with Ands an Ors incorporated, but I know there is an easier way to reference tables rather than type out 6 different OR statements for State-County for example.

The if function would be =If(AND(OR(State-County = any of the ones in table 1), OR(Prop Type = any of the ones in table 2), OR(Product = any of the ones in table 3), "Yes","No")

Does anyone know how to do this in a way that I can just reference the tables rather than have to type out every single OR statement?

Thanks.

 

[CA_Punit]

Book1
	A	B	C	D	E	F	G	H	I
2	Criteria
3	17-34	4	S40			Table 1	Table 2	Table 3
4						17-31	1	S30
5						17-32	2	S20
6		FALSE				17-33	3	S10
7						17-34	4	HR30
8
9
10
11
Sheet2

Cell Formulas
Range	Formula
B6	B6	=IF(NOT(ISERROR(MATCH(A3,F4:F7,0)*MATCH(B3,G4:G7,0)*MATCH(C3,H4:H7,0))),TRUE,FALSE)

 

[SanFelippo]

This looks to be working perfectly. Thanks a bunch!