AustinS
10-26-2011, 10:19 AM
This is confusing and I can't figure out how to make it work.
I have cells that have numbers separated by commas.
e.g., A1: "1,2,3,4"
I want to separate those numbers out and perform a vlookup on each number and concatenate the results into one cell.
So in another tab it might have
1|sentence1
2|sentence2
3|sentence3
4|sentence4
I need to loop through Cell A1-A50 (or whatever) and read out 1,2,3,4 and do vlookups on the other tab and make a concatenation of sentence1sentence2sentence3 into one cell.
I'm failing hard at making this work. Any help is greatly appreciated.
I have cells that have numbers separated by commas.
e.g., A1: "1,2,3,4"
I want to separate those numbers out and perform a vlookup on each number and concatenate the results into one cell.
So in another tab it might have
1|sentence1
2|sentence2
3|sentence3
4|sentence4
I need to loop through Cell A1-A50 (or whatever) and read out 1,2,3,4 and do vlookups on the other tab and make a concatenation of sentence1sentence2sentence3 into one cell.
I'm failing hard at making this work. Any help is greatly appreciated.