2 VLookups

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 !

Basic assumptions:
All Product Groups have a multiplier. Some part numbers have a multiplier.
If the individual part number has a multiplier, use it, otherwise use the
basic product group multiplier.
Assumption #2: The Product Group Multiplier and the Part Number multiplier
are on their own separate tables. Data!$A$2:$B$100 is defined as
Tbl_ProdMult, Data!$D$2:$E$1000 is defined as Tbl_PartMult, and
Data!$D$2:$D$1000 is defined as PartMult.

in cell D2 (and copy down as needed, this will give you the Multiplier in
column D, not sure what you actually want in column D, the multiplier, or the
list*multiplier).
=IF(COUNTIF(PartMult,A2)=0,VLOOKUP(B2,Tbl_ProdMult ,2,FALSE),VLOOKUP(A2,Tbl_PartMult,2,FALSE))

--
John C


"Guitarbuyer" wrote:

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 !