Excel Look Up Tables - Make The Table Dynamic?
Hi
"T. Valko" wrote in message
...
NB:
If your named ranges are *dynamic ranges* then a different formula will be
needed. If that's the case this adds that extra step back into the process
and you might as well just stick with a combo box.
Not at all!
An example:
=CHOOSE(MATCH(A1,{Value1;Value2;Value3;...},0),Ran ge1,Range2,Range3,...)
--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )
|