The first formula has 7 nested IF's, what is a max number of nesting allowed!
Workarounds:
a) Use 'subnesting', i.e. use an IF() to divide your single-column conditions into 2 or more groups of conditions, and then use nested IF's <like = IF(StartCondition, IF(... subnest 1 ...), IF(... subnest 2 ...))>;
b)Use formula instead like
Code:
(VLOOKUP(...)&""="")*(VLOOKUP(...)&""="")*...*VLOOKUP(...)
+
(VLOOKUP(...)&""="")*(VLOOKUP(...)&""="")*...*VLOOKUP(...)
+
...
c) Use helper column in your table to calculate the number of return column of VLOOKUP. Your formula will be like
Code:
=VLOOKUP(A219,Form1!$A:$X,HelperColumnValue,FALSE)