Forum Discussion
Shorten excel formula for data validation
Hello I was wondering if someone could help me shorten a formula as my current formula (below) is too long for data validation. =IF(C10="KABI 8",48,IF(C10="KABI 11",64,IF(C10="KABI 14",80,IF(...
Hi,
Better to keep you constants in helper range - shorter the formula and much easier in maintenance. After that like
=IFNA(INDEX($F$1:$F$14,MATCH(C10,$E$1:$E$14,0)),"")
see attached
