View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wendy Wendy is offline
external usenet poster
 
Posts: 99
Default formula question

Need help. Need to be able to basically perform 2 vlookups. Here is the
example:

Division Part # Cost/ LB Cost/ingredient
12 1253 5 0.8
12 1246 2 0.3
13 1234 1 0.5
13 1278 3 0.6
14 1278 3 0.6
15 1234 1 0.5

I want to be able to write a formula that finds the division number and for
that division number, find the part number I specify and then give me the
cost per pound or cost per ingredient. Can someone help me please? Thanks.