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 <9AB093CA-4D8F-47BD-AE09-52665BCAEA1B@microsoft.com>,
"Bob S" <BobS@discussions.microsoft.com> 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})