LOOKUP question

[Bob S]

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

 

[Domenic]

Try...

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

Hope this helps!