Search and replace from a table of mapped values?

[keith]

I have a column of numeric values that I want to replace with an associated alphanumeric value.

Column A has a list of the various numeric values
Column B is the destination for the matching alphanumeric value
Column C&D have the original numeric/alphanumeric mappings, with each mapping being in the same row.

So the macro would look at A4, then look down column C to find the match. Then it would look at the corresponding value in Column D that would be entered in Column B.


Any suggestions?

Thanks

 

[SirJB7]

Hi, keith!

As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

Regards!

 

[NARAYANK991]

Hi Keith ,

1. It would be easier to test a macro if the data is available ; can you upload your working file ?

2. Is it guaranteed that there will always be a match ? In case there is no match , what is to be done ?

3. Given any numeric value in column A , will there be only one match in column C ? What is to be done if there are multiple matches ?

Narayan