View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Koomba Koomba is offline
external usenet poster
 
Posts: 14
Default 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