sungjinyun
New member
- Joined
- Jan 25, 2012
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hello I have a cell in one sheet containing some values separated by a comma
1, 2, 3...etc
I have another excel workbook that has codes:
cell a2 has (codes column):
1, 2, 3,...etc.
cell b2 has (code translation column)
A, B, C...etc
What is a good vertical lookup formula to use so that in the original sheet it will return all the values of that cell? I know how to make one vertical lookup formula, but it will only work if there is only one value in the cell. If it has up to 8 values, I need the 8 corresponding results. HELP PLEASE!
1, 2, 3...etc
I have another excel workbook that has codes:
cell a2 has (codes column):
1, 2, 3,...etc.
cell b2 has (code translation column)
A, B, C...etc
What is a good vertical lookup formula to use so that in the original sheet it will return all the values of that cell? I know how to make one vertical lookup formula, but it will only work if there is only one value in the cell. If it has up to 8 values, I need the 8 corresponding results. HELP PLEASE!