A	B	C	D	E	F	G	H	I	J	K	L	M	N
2
3		FindIf
4
5		Category:	Range Operations
6		Family:	Range Lookup
7		Arguments:	InpList, OutList, Criteria, [FindSwitch], [CritOpts]
8		Meaning:	Find one or more values in a list, depending on criteria
9		Description:
10
11
12			InpList		OutList		Criteria
13			1		10		>6
14			2		20		mod(?,2)=0
15			3		30
16			4		40
17			5		50
18			6		60
19			7		70
20			8		80
21
22
23		FindIf		20
24		FindIf (Array Function)		20	40	60	70	80
25
26		FindIf (returning Position)		2
27		FindIf (returning Positions)		2	4	6	7	8
28
29		FindIf (Diff. Orientation)		20
30				20
31				20
32				20
33				20
34				20
35				20
36
37
38		Example 2: No OutList, using AND conditions in a single Criteria Cell
39
40			InpList				Criteria
41			1				and(?>1,?<5)
42			2
43			3
44			4
45			5
46			6
47			7
48			8
49
50
51		FindIf		2
52		FindIf (Array Function)		2	3	4
53
54
55		Example 3: Same thing using separate AND criteria
56
57			InpList				Criteria
58			1				?>1
59			2				?<5
60			3
61			4
62			5
63			6
64			7
65			8
66
67
68		FindIf		2
69		FindIf (Array Function)		2	3	4
70
71
72
73
74
75
76
77
78
79
80