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,FAL SE))
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.

--
Message posted via http://www.officekb.com

=IF($A2="Retail",VLOOKUP($A2,retail!$A$3:$H$200,2, FALSE),if($A2="Distributor",VLOOKUP($A2,Distributo r!$A$3:$H$200,2,FALSE),VLOOKUP($A2,Wholesale!$A$3: $H$200,2,FALSE),"")

should work, but i have not tested it

"inta251 via OfficeKB.com" wrote:

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,FAL SE))
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.

--
Message posted via http://www.officekb.com

sorry finger problem whilst typing... try
=IF($A2="Retail",VLOOKUP($A2,retail!$A$3:$H$200,2, FALSE),if($A2="Distributor",VLOOKUP($A2,Distributo r!$A$3:$H$200,2,FALSE),if($A2="Wholesale",VLOOKUP( $A2,Wholesale!$A$3:$H$200,2,FALSE),"")


"LesG" wrote:

=IF($A2="Retail",VLOOKUP($A2,retail!$A$3:$H$200,2, FALSE),if($A2="Distributor",VLOOKUP($A2,Distributo r!$A$3:$H$200,2,FALSE),VLOOKUP($A2,Wholesale!$A$3: $H$200,2,FALSE),"")

should work, but i have not tested it

"inta251 via OfficeKB.com" wrote:

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,FAL SE))
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.

--
Message posted via http://www.officekb.com

LesG wrote:
sorry finger problem whilst typing... try
=IF($A2="Retail",VLOOKUP($A2,retail!$A$3:$H$200,2 ,FALSE),if($A2="Distributor",VLOOKUP($A2,Distribut or!$A$3:$H$200,2,FALSE),if($A2="Wholesale",VLOOKUP ($A2,Wholesale!$A$3:$H$200,2,FALSE),"")

=IF($A2="Retail",VLOOKUP($A2,retail!$A$3:$H$200,2, FALSE),if($A2="Distributor",VLOOKUP($A2,Distributo r!$A$3:$H$200,2,FALSE),VLOOKUP($A2,Wholesale!$A$3: $H$200,2,FALSE),"")


Thanks LesG.

A1=list (names worksheets: Retail, Distributor and Wholesale)
A2=item #
as you see i need 2 criteria A1 and A2.

--
Message posted via http://www.officekb.com

OK. Thanks again LesG.
Now working fine.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200909/1