2 VLookups

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 !
 
J

John C

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top