Mapping values from an index!!?? HELP!

B

BCBS_exceller

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

BCBS_exceller

Thanks JMB!

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

JMB

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top