Thread: Lookup formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Workin girl[_2_] Workin girl[_2_] is offline
external usenet poster
  
Posts: 4
Default Lookup formula
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"})
Reply With QuoteReply With Quote