LOOKUP question-s it possible to have LOOKUP do a calculation in the array?

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

Try...

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

Hope this helps!

In article <[email protected]>,
"Bob S" <[email protected]> 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})