G
Guitarbuyer
Hi,
I am using Excel 2003 on Vista Ultimate. I need to find the value of a cell
if the part number or product group is used. Here is the example
A1: Part Number
A2: Product Group
A3: List Price
A4: Vlookup field. I need to lookup if the part number is applicable to
return the list price * a multiplier. If the product group is applicable,
list price * a multiplier. So, if the part number has a multiplier, use it,
or if the product group has one, use it. I know this is a bit confusing, but
ask away and I will try to answer questions.
Thanks !
I am using Excel 2003 on Vista Ultimate. I need to find the value of a cell
if the part number or product group is used. Here is the example
A1: Part Number
A2: Product Group
A3: List Price
A4: Vlookup field. I need to lookup if the part number is applicable to
return the list price * a multiplier. If the product group is applicable,
list price * a multiplier. So, if the part number has a multiplier, use it,
or if the product group has one, use it. I know this is a bit confusing, but
ask away and I will try to answer questions.
Thanks !