Find (x), insert If statement to right

[BEEJAY]

Greetings:

Have multiple workbooks, totalling thousands of rows to check.
When text (P.O.A.) is found in column F, Column E needs to have a "1" inserted, and Column G requires an IF Statement.

I'm drawing a blank on how to search for the text "P.O.A."

The adjustment required on cell to the left works as shown.

The Insertion of the IF statement is not working either.
1: Doesn't matter what I try with the quote marks, it always comes up with "compile error: Expected end of statement".
If I drop the equals sign in front of the IF, it will insert the text into the cell, but that is not what is needed.
2: The IF statement must indicate the row number that it is being inserted on.

I understand that looping is not the most efficient way to do multiple instances.
Efficiency is a concern, due to size of workbooks.

Thank-you

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

You need double quotes round the space literal.

i.e.

Please Login or Register  to view this content.

Regards

[BEEJAY]

Thanks Richard:

I've changed that line. It does insert the IF statement, BUT, it also adds single quotes around the cell address.
Obviously more code is needed to make this work, so that the cell address will 'match' the row that the IF statement is placed on.

Please Login or Register  to view this content.

What is actually inserts into the Cell is: =IF('E51'<>0,'F51'," ")
What would be the next step?

[Richard Buttrey]

Hi,
Try

Please Login or Register  to view this content.

[BEEJAY]

Perseverance does sometimes pay off.

I now have the following, which seems to the trick.
The only thing left now, is to loop or repeat the code.
Any Ideas? I can't use go to blank space, or anything link that.
I could use column B as finding last row.
??

Please Login or Register  to view this content.