hello world,
I have a table like this. with the first column having main items and the second column having strings separated by plus signs
then, on another spreadsheet I have the strings in the first column and their descriptions in the second column
I want to be able to find every string value separated by the plus signs, look them up on the other sheet and replace them with their descriptions. I have no idea where to start. This is a huge spreadsheet by the way. Tens of thousands of lines. I could have a variable number of items separated by plus signs. this is driving me insane. I don't even know where to start, so I came here.
[/QUOTE]
is that clear enough or should I provide more data? dude called doc scared me a little about how to properly post. thanks.
I have a table like this. with the first column having main items and the second column having strings separated by plus signs
22222222 | 1111 + 3333 + 4444 + 6666 |
77777777 | 3333 + 4444 + 6666 + 1111 |
then, on another spreadsheet I have the strings in the first column and their descriptions in the second column
1111 | a1 |
3333 | a3 |
4444 | a4 |
6666 | a6 |
I want to be able to find every string value separated by the plus signs, look them up on the other sheet and replace them with their descriptions. I have no idea where to start. This is a huge spreadsheet by the way. Tens of thousands of lines. I could have a variable number of items separated by plus signs. this is driving me insane. I don't even know where to start, so I came here.
22222222 | a1 + a3 + a4 + a6 |
77777777 | a3 + a4 + a6 + a1 |
is that clear enough or should I provide more data? dude called doc scared me a little about how to properly post. thanks.