Using Lookup to locate Price from Drop-down List
Xcel2003
Am developing an Sales Order for our small business. We have 11 products;
and trying to assign Price (C4) based on Product (B4). IF statements work,
but only up to 8 conditions. Have experimented with Lookup, Match, Index, but
cannot get anything to work.
--
Thanks from Salt Spring
|