Thread: Lookup formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Lookup formula

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