Lookup formula

[Workin girl]

I have entered the below formula in my worksheet but get a #N/A. What am I
doing wrong?

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

 

[Dave Peterson]

What does:
=sum(e38:e41)
return?

What should happen if it's less than 4?

 

[Gord Dibben]

=SUM(E38:E41) must equal a minimum of 4

And why do you want the returns to be Text values?

I would drop the double quotes.


Gord Dibben MS Excel MVP

 

[Sean Timmons]

Is your sum of E38 to E41 less than 4? Or is one of the values in that range
shwoing #N/A?