M
Michel Khennafi
Good evening....
In a worksheet W1, I have a situation where I an order number O1 that has
been shipped in 1 to N shipments S1, S2,...Sn.
In a worksheet W2, I have rows that represent the shipments but I only have
the order number 01 to identify them.
I would like to add a column and assign each row where O1 is the Shipment
numbers S1 to Sn.
On W1
A B
__ __
1 O1 S1
2 O1 S2
On W2
A B
__ __
1 O1 (Blank)
2 O1 (blank)
Desired Result on W2
A B
__ __
1 O1 S1
2 O1 S2
If I use Vlookup I will only be able to match one for one, so If I put
B1=+vlookup(A1,W2!A1:B2,2,False) I can get the value for the first row (in
that case S1)... What would be the trick to guarantee that I would have S2
on W2!B2?
Any help greatly appreciated
Thanks
In a worksheet W1, I have a situation where I an order number O1 that has
been shipped in 1 to N shipments S1, S2,...Sn.
In a worksheet W2, I have rows that represent the shipments but I only have
the order number 01 to identify them.
I would like to add a column and assign each row where O1 is the Shipment
numbers S1 to Sn.
On W1
A B
__ __
1 O1 S1
2 O1 S2
On W2
A B
__ __
1 O1 (Blank)
2 O1 (blank)
Desired Result on W2
A B
__ __
1 O1 S1
2 O1 S2
If I use Vlookup I will only be able to match one for one, so If I put
B1=+vlookup(A1,W2!A1:B2,2,False) I can get the value for the first row (in
that case S1)... What would be the trick to guarantee that I would have S2
on W2!B2?
Any help greatly appreciated
Thanks