Arunachaljois
Board Regular
 Joined
 Aug 1, 2020
 Messages
 57
 Office Version

 365
 Platform

 Windows
Finding issue in If elseif else with For each Loop
I have tried this below code but i'm getting in Y column filled with W005. Colud you please help me on this ? i have uploaded a images also.
For Each cell In Range("I2:I" & LR)
If cell.Value = "W100" Then
Range("Y2:Y" & LR).Formula = "=CONCATENATE(RC[23],""000"",RC[20],""W004"")"
ElseIf cell.Value = "W102" Then
Range("Y2:Y" & LR).Formula = "=CONCATENATE(RC[23],""000"",RC[20],""W005"")"
Else
Range("Y2:Y" & LR).Formula = "=CONCATENATE(RC[23],""000"",RC[20],RC[16])"
End If
Next cell
I have tried this below code but i'm getting in Y column filled with W005. Colud you please help me on this ? i have uploaded a images also.
For Each cell In Range("I2:I" & LR)
If cell.Value = "W100" Then
Range("Y2:Y" & LR).Formula = "=CONCATENATE(RC[23],""000"",RC[20],""W004"")"
ElseIf cell.Value = "W102" Then
Range("Y2:Y" & LR).Formula = "=CONCATENATE(RC[23],""000"",RC[20],""W005"")"
Else
Range("Y2:Y" & LR).Formula = "=CONCATENATE(RC[23],""000"",RC[20],RC[16])"
End If
Next cell