G
Guest
Help.
I have two columns of data. One is a receipt number the other is an order
number. Basically, I want to create a lookup/index that will show me all
the order numbers associated to a receipt in one cell. i.e. Each receipt
can be for more than one order.
I've got this so far.
=INDEX(fgnpo!$A$2:$B$14001,MATCH(M2,fgnpo!$A$2:$A$14001,0),2)
This will return one of the values, but not all of them.
Here's part of the list.
Receipt Order
12668
26685
12669 26615
12670 26630
12671 26145
12671 26458
12671 26591
What I want is it to show
Receipt Order
12668 26685
12669 26615
12671 26630
12671 26145, 26458, 26591.
Is this possible?
Please help.
Many thanks
No spam! )
I have two columns of data. One is a receipt number the other is an order
number. Basically, I want to create a lookup/index that will show me all
the order numbers associated to a receipt in one cell. i.e. Each receipt
can be for more than one order.
I've got this so far.
=INDEX(fgnpo!$A$2:$B$14001,MATCH(M2,fgnpo!$A$2:$A$14001,0),2)
This will return one of the values, but not all of them.
Here's part of the list.
Receipt Order
12668
26685
12669 26615
12670 26630
12671 26145
12671 26458
12671 26591
What I want is it to show
Receipt Order
12668 26685
12669 26615
12671 26630
12671 26145, 26458, 26591.
Is this possible?
Please help.
Many thanks
No spam! )