Using Lookup to locate Price from Drop-down List

K

Koomba

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.
 
A

Ashish Mathur

Hi,

You will need to use a simple Vlookup() function. Please read up on the
VLOOKUP() function in Excel's help menu.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Top