AND/OR Lookup Using IF

	A	B	C	E	F	H	I	J
1	Animal	Color	Value	Horse	Red	Pig	Red	978
2	Pig	Red	978	Pig		Pig	Red	373
3	Horse	Green	484			Horse	Red	500
4	Dog	Red	384
5	Pig	Green	628
6	Pig	Green	969
7	Fish	Green	523
8	Bird	Blue	357
9	Horse	Blue	785
10	Cat	Orange	871
11	Bird	Blue	273
12	Pig	Blue	304
13	Bird	Blue	770
14	Bird	Orange	316
15	Horse	Green	569
16	Horse	Blue	576
17	Pig	Green	415
18	Dog	Blue	820
19	Fish	Blue	118
20	Bird	Red	395
21	Cat	Green	976
22	Pig	Blue	322
23	Bird	Orange	709
24	Fish	Blue	500
25	Dog	Orange	272
26	Dog	Green	541
27	Horse	Orange	986
28	Pig	Green	802
29	Pig	Blue	652
30	Cat	Orange	153
31	Dog	Orange	785
32	Dog	Red	598
33	Pig	Orange	543
34	Cat	Red	818
35	Horse	Orange	653
36	Horse	Green	983
37	Cat	Red	434
38	Fish	Green	622
39	Pig	Blue	387
40	Cat	Orange	470
41	Dog	Orange	358
42	Cat	Blue	176
43	Pig	Orange	731
44	Bird	Blue	495
45	Fish	Blue	671
46	Bird	Red	734
47	Bird	Orange	809
48	Cat	Orange	332
49	Cat	Blue	850
50	Pig	Red	373
51	Cat	Orange	158
52	Dog	Orange	416
53	Fish	Red	434
54	Dog	Green	854
55	Dog	Red	767
56	Horse	Orange	650
57	Cat	Green	640
58	Bird	Green	854
59	Bird	Red	800
60	Dog	Green	278
61	Dog	Red	946
62	Fish	Red	425
63	Pig	Orange	352
64	Fish	Red	747
65	Dog	Blue	794
66	Dog	Red	370
67	Pig	Blue	624
68	Horse	Blue	851
69	Horse	Orange	400
70	Bird	Blue	890
71	Cat	Blue	968
72	Cat	Red	998
73	Horse	Red	500
74	Pig	Green	766
75	Dog	Red	540
76	Cat	Green	884
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100