close
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 gt;,
quot;Bob Squot; gt; wrote:
gt; Is it possible to have LOOKUP do a calculation in the array part instead of
gt; just displaying the values in the array? As in
gt; =LOOKUP(G24,{1,2,3},{C1 C2,D1 D2,E1 E2})
全站熱搜
留言列表
