If then?

[288enzo]

In one of 2 columns of data I have what starts out as 3 digit codes, such as WTA PAA PRK LFF all in the same cell, and use a macro to change those three letters into something a bit easier to read.

Please Login or Register  to view this content.

What I would like to be able to accomplish is making the above dependent on what is in the cell next to it, meaning if A1 is "36" and I have "WTA" in A2 then "WTA" would be replaced with "BASIC CODE"; however if in A1 I have "39" and "WTA" in A2 then I would want "WTA" to be replaced with "BASIC CODE OPTION 3".

Thank you.

Moderators note: code tags added for you - this time

[FDibbins]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[protonLeah]

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

With codes and replacements sheet

[288enzo]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Sorry about that, thank you for fixing it.

[JOHN H. DAVIS]

Maybe something like this can get you started?

Please Login or Register  to view this content.

[288enzo]

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

With codes and replacements sheet

I've uploaded it. Thank you.

test.xlsm

[288enzo]

Maybe something like this can get you started?

Please Login or Register  to view this content.

Thank you for the suggestion. I tried it out, it looks like perhaps it is only going to work based on one cell and not all. Typically I'll have 100 or more that need to be converted.