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"})

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

What should happen if it's less than 4?



Workin girl wrote:

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

=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

On Thu, 15 Oct 2009 08:30:53 -0700, Workin girl
wrote:

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"})

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

"Workin girl" wrote:

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"})