if values in Column D matches then

[GirishDhruva]

Hi everyone,
I had created same thread https://www.mrexcel.com/forum/excel-questions/1098491-if-values-column-d-matches-then.html but as i couldn't view that thread i have created this.

Here i am trying to check the values in column 'D' and if the values in column 'D' matches then in column B it should print the value '60' else it should print '10'.


Like

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]60[/TD]
[TD]4359[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10[/TD]
[TD]45132[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10[/TD]
[TD]'4324[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]10[/TD]
[TD]1324[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]10[/TD]
[TD]5123[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]60[/TD]
[TD]'4359[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]10[/TD]
[TD]06471[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]10[/TD]
[TD]12345[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]60[/TD]
[TD]'4359[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]10[/TD]
[TD]53121[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]60[/TD]
[TD]4359[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]10[/TD]
[TD]'5123[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]10[/TD]
[TD]512323[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]60[/TD]
[TD]4359[/TD]
[/TR]
</tbody>[/TABLE]

The values in column 'D' can also be text

Thanks in advance

 

[GirishDhruva]

Hi Everyone,
I am not very much good in coding but i am trying below code as it's throwing me an error in highlighted, can i know why????

lrow = Cells(Rows.Count, "D").End(xlUp).Row
For i = 4 To lrow
    If Cells(i, 1).Value = "4359" Then
        Range(Cells(Rows(i), "B")).Value = "60"
    Else
        Range(Cells(Rows(i), "B")).Value = "10"
    End If
Next i

 

[My Aswer Is This]

Try this:

Sub My_Sub()
'Modified  5/22/2019  2:01:01 AM  EDT
lrow = Cells(Rows.Count, "D").End(xlUp).Row
For i = 4 To lrow
    If Cells(i, "D").Value = "4359" Then
        Cells(i, "B").Value = "60"
    Else
        Cells(i, "B").Value = "10"
    End If
Next i
End Sub

 

[GirishDhruva]

Thanks it works exactly

 

[My Aswer Is This]

Glad I was able to help. But in your original post you said:

Here i am trying to check the values in column 'D' and if the values in column 'D' matches

But you did not say matches "4359"

There are numerous different values in column D

I would think in this case you would have said matches "4359"
​

 

[GirishDhruva]

Glad I was able to help. But in your original post you said:

Here i am trying to check the values in column 'D' and if the values in column 'D' matches

But you did not say matches "4359"

There are numerous different values in column D

I would think in this case you would have said matches "4359"
​

Ya i think i have confused , sorry for that

 

[My Aswer Is This]

OK:

Ya i think i have confused , sorry for that