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????

In E1, try

=VLOOKUP(A1,B$1:C$5,2,0)

and copy down.


"BCBS_exceller" wrote:

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????

Thanks JMB!

My head was spinning with VLOOKUP, INDEX, and MATCH functions... : (

JMB wrote:
In E1, try

=VLOOKUP(A1,B$1:C$5,2,0)

and copy down.


"BCBS_exceller" wrote:

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????

Just for future reference, the index/match solution would be:
=INDEX(C$1:C$5, MATCH(A1, B$1:B$5, 0))

which would be useful if the data to be returned is to the left of the key
column - since Vlookup is limited to returning data to the right of the key
column.


"BCBS_exceller" wrote:

Thanks JMB!

My head was spinning with VLOOKUP, INDEX, and MATCH functions... : (

JMB wrote:
In E1, try

=VLOOKUP(A1,B$1:C$5,2,0)

and copy down.


"BCBS_exceller" wrote:

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????