ISNUMBER(SEARCH problem

[coop123]

I have a problem with the section of code below.

I am trying to put EHP in column F if customer begins with GB or PL or E.

If I only have if customer begins with GB or PL macro works, if I add additional criteria if customer begins with E it fails.

Range("F444").Select
ActiveCell.FormulaR1C1 = _
"=IF(OR(ISNUMBER(SEARCH(""GB"",RC[-5])),ISNUMBER(SEARCH(""PL"",RC[-5]))),ISNUMBER(SEARCH(""E"",RC[-5])))),""EHP"","""")"

Can someone please advise what mistake I have made, or is there another way to achieve putting EHP in column F if customer in column A starts with GB or PL or E.

There is code for the other customer ABC which works fine.

Thanks inadvance

Coop123

 

[Fluff]

You have an extra closing bracket after looking for PL, it should be

Range("F4").FormulaR1C1 = _
"=IF(OR(ISNUMBER(SEARCH(""GB"",RC[-5])),ISNUMBER(SEARCH(""PL"",RC[-5])),ISNUMBER(SEARCH(""E"",RC[-5]))),""EHP"","""")"

 

[coop123]

Thank you Fluff.

Works perfectly now.

I had looked and looked at the line and could see what was wrong. Fresh pair of eyes solves the problem.

Thank you again.

Coop123

 

[Fluff]

Glad to help & thanks for the feedback.