Thread: LOOKUP question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob S
 
Posts: n/a
Default LOOKUP question

Is it possible to have LOOKUP do a calculation in the array part instead of
just displaying the values in the array? As in
=LOOKUP(G24,{1,2,3},{C1+C2,D1+D2,E1+E2})