Try...

=CHOOSE(MATCH(G24,{1,2,3}),C1+C2,D1+D2,E1+E2)

Hope this helps!

In article ,
"Bob S" wrote:

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