bmwbuyer2007
Board Regular
- Joined
- Jul 19, 2007
- Messages
- 82
hi all,
I have 2 sheets in my workbook, with very simple data:
Sheet 1
Count Product
3 A
11 A1
3 A2
1 A3
1 A4
1 A6
Sheet 2
Count Product
2 A
1 AL
1 AM
2 A3
3 A2
11 A5
I would like a formula in sheet 2, column C, which will look for the product code in sheet 1 and return the figure to the left of it, so sheet 2 will then look like:
Sheet 2
Count Product Count 2
2 A 3
1 AL
1 AM
2 A3 1
3 A2
11 A5 3
Any ideas please?
Thanks
I have 2 sheets in my workbook, with very simple data:
Sheet 1
Count Product
3 A
11 A1
3 A2
1 A3
1 A4
1 A6
Sheet 2
Count Product
2 A
1 AL
1 AM
2 A3
3 A2
11 A5
I would like a formula in sheet 2, column C, which will look for the product code in sheet 1 and return the figure to the left of it, so sheet 2 will then look like:
Sheet 2
Count Product Count 2
2 A 3
1 AL
1 AM
2 A3 1
3 A2
11 A5 3
Any ideas please?
Thanks