Two IF statements that result in added text to cell

**daedelous00** · 07-13-2012, 09:00 AM

Hello! First time posting here. I know very little VBA but am usually I'm able to find what I need by scouring the web. Unfortunately, this is a fairly specific problem and I can't find it on my own. I was hoping someone nice could help me out here.

WHAT I NEED:

If D3A, D3B, D6A, or D6B appear anywhere in a cell in column AB, and there is data in its adjacent cell in column AC, then add 001 to the front of the data in the cell in column AC.

Thank you!

-Adam

**StevenM** · 07-13-2012, 09:21 AM

Backup your data!
Copy code to a standard module.
Run: ModifyData

Please Login or Register  to view this content.

**dilipandey** · 07-13-2012, 09:27 AM

Hi Adam,

Welcome to the forum.

See the attached file where I have used If and OR functions to achieve the desired results:-

Two If statements.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

**daedelous00** · 07-13-2012, 10:22 AM

StevenM,

Thanks! I had to add another line in there to format the column as text so it would show the preceding zeroes.

Dili,

Thanks for the formulas. I should have said that adding another column wasn't really an option. I had to change the current one so I needed a script I believe.