J
Johnds
Hi,
I've got a list of invoice numbers against items purchased. Some invoices
have more than one item (multiple items) purchased as follows:
A B
1 Invoice Number Item Purchased
2 181 ACCESSORY
3 181 COMPUTER
4 181 CAMERA
5 180 ACCESSORY
6 179 CAMERA
7 179 CONSOLE
8 177 COMPUTER
9 176 COMPUTER
10 176 COMPUTER
11 175 CAMERA
I need a lookup type formula in cell B2 to B7 where I get the results as
below:
A B
1 Invoice Number Property Description
2 181 ACCESSORY, COMPUTER, CAMERA
3 180 ACCESSORY
4 179 CAMERA, CONSOLE
5 177 COMPUTER
6 176 COMPUTER, COMPUTER
7 175 CAMERA
Does anybody have any ideas? Any help would be gratefully received.
Thank-you,
John
I've got a list of invoice numbers against items purchased. Some invoices
have more than one item (multiple items) purchased as follows:
A B
1 Invoice Number Item Purchased
2 181 ACCESSORY
3 181 COMPUTER
4 181 CAMERA
5 180 ACCESSORY
6 179 CAMERA
7 179 CONSOLE
8 177 COMPUTER
9 176 COMPUTER
10 176 COMPUTER
11 175 CAMERA
I need a lookup type formula in cell B2 to B7 where I get the results as
below:
A B
1 Invoice Number Property Description
2 181 ACCESSORY, COMPUTER, CAMERA
3 180 ACCESSORY
4 179 CAMERA, CONSOLE
5 177 COMPUTER
6 176 COMPUTER, COMPUTER
7 175 CAMERA
Does anybody have any ideas? Any help would be gratefully received.
Thank-you,
John