Hi,
I have a sheet like the one below:
A B
1 34
1 32
1 20
2 10
2 4
2 9
2 100
I would like to use a vlookup that looks up the value in column A and returns a string of all the values in B. E.g If i was looking up 1 it would return 34 32 20 as one text string.
I'm not too good at Arrays and Indexes etc so don't know what to use to do this.
Any help would be greatly appreciated. Many Thanks in advance.
Dixon
I have a sheet like the one below:
A B
1 34
1 32
1 20
2 10
2 4
2 9
2 100
I would like to use a vlookup that looks up the value in column A and returns a string of all the values in B. E.g If i was looking up 1 it would return 34 32 20 as one text string.
I'm not too good at Arrays and Indexes etc so don't know what to use to do this.
Any help would be greatly appreciated. Many Thanks in advance.
Dixon