I would like to construct an indicator function, however, preferably not with millions of nested if functions. I need it for situations like this:
YV VA OE TM Indicator
9 YV
4 YV
5 YV
6 YV
7 YV
6 YV
7 YV
23 VA
3 VA
5 VA
5 VA
3 YV
6 OE
6 OE
3 OE
2 VA
2 TM
1 YV
2 TM
2 TM
1 TM
A nested IF function works here for me to create the indicator. However, if I had 40 fields instead of 4 then I couldn't use this method. I am guessing that using a correct lookup function would do it but I am not sure how to go about it. Thanks.
YV VA OE TM Indicator
9 YV
4 YV
5 YV
6 YV
7 YV
6 YV
7 YV
23 VA
3 VA
5 VA
5 VA
3 YV
6 OE
6 OE
3 OE
2 VA
2 TM
1 YV
2 TM
2 TM
1 TM
A nested IF function works here for me to create the indicator. However, if I had 40 fields instead of 4 then I couldn't use this method. I am guessing that using a correct lookup function would do it but I am not sure how to go about it. Thanks.