If the sum if less than 4 then the formula will return an error.

Either add one more element to the lookup array as below
=LOOKUP(SUM(E38:E41),{0,4,7,11,15,19},{"","1","2", "3","4","5"})

OR handle that using IF
=IF(SUM(E38:E41)3,LOOKUP(SUM(E38:E41),{4,7,11,15, 19},{"1","2","3","4","5"}),"")


If this post helps click Yes
---------------
Jacob Skaria


"Workin girl" wrote:

I have entered the below formula into my spreadsheet but get a #NA. What am
I doing wrong??

=LOOKUP(SUM(E38:E41),{4,7,11,15,19},{"1","2","3"," 4","5"})