Hi all:

I have a list of values which I need referenced and mapped from an
index but am not sure how to go about it. I have tried VLOOKUP but I
dont think that is the way to go about it.

For example...

I have 10 values in Column 1 but not all are the same:
Values
Column (A)
1,
2,
2,
4,
1,
3,
5,
....
The mapping index would be as follows from B (being referenced values
for column A) and C (being new values to be mapped)
Values
Column (B)
1,
2,
3,
4,
5
....

Column (C)
A,
B,
C,
D,
E
....

My expected result would have these remapped out to
reference A to C and display in Column E

A,
B,
B,
D,
A,
C,
E,
.....


I know this should be simpler than it sounds...

Any suggestions????