I
inta251 via OfficeKB.com
4 worksheets
1-Retail
2-Distributor
3-Wholesale
in first 3 worksheets
columnA item #
columnB item price
on each worksheet price is different
4-Order
A1=list (names worksheets: Retail, Distributor and Wholesale)
A2=item #
B2= need add to formula
=IF($A2="","",VLOOKUP($A2,retail!$A$3:$H$200,2,FALSE))
if in cell A1 = Retail LOOK in retail worksheet OR
A1 = Distributor LOOK in distributor worksheet OR
A1 = Wholesale LOOk in wholesale worksheet
Thanks in advance.
1-Retail
2-Distributor
3-Wholesale
in first 3 worksheets
columnA item #
columnB item price
on each worksheet price is different
4-Order
A1=list (names worksheets: Retail, Distributor and Wholesale)
A2=item #
B2= need add to formula
=IF($A2="","",VLOOKUP($A2,retail!$A$3:$H$200,2,FALSE))
if in cell A1 = Retail LOOK in retail worksheet OR
A1 = Distributor LOOK in distributor worksheet OR
A1 = Wholesale LOOk in wholesale worksheet
Thanks in advance.