D7 is a dropdown list of customer names. F16 is a drop down list of products.
J16 is where I would like a price to be shown based on the price from another
folder called PartTable. PartTable contains numerous columns. Product ID,
Cntr Size, Cntr Desc, Cost are the first four columns. Next columns E thru V
contain product pricing for 6 customers. Each customer has 3 columns (Colum1
is ea price, Column 2 is Case Price, and Column 3 is GM%).
In a folder called CustTable, in cell C1 the following formula is
used=IF(OriginalInvoicepg1!D7="","",VLOOKUP(Origin alInvoicepg1!D7,CustTable!A:B,2,FALSE))
to identify the customer on "OriginalInvloicepg1" page (D7). My question is
how do I get the cell J16 on "OriginalInvoicepg1" to show the price from the
"PartTable" page. Keeping in mind the Case Pricing columns for the 6
customers are a different amount.
I was given a formula of
=if(custtable!$c$1="",9999999,vlookup(f16,parttabl e!A:X,custtable!$c$1,false)). I get a #ref! error message on this. Any suggestions?
Pete Elbert. I will be happy to email the spread sheet for a more clear
explanation.