#### sungjinyun

##### New member

- Joined
- Jan 25, 2012

- Messages
- 2

- Reaction score
- 0

- Points
- 0

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!