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})
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})
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks