Mapping values from an index!!?? HELP!
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???? |
Mapping values from an index!!?? HELP!
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???? |
Mapping values from an index!!?? HELP!
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???? |
Mapping values from an index!!?? HELP!
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???? |
All times are GMT +1. The time now is 02:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com