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

Column A	Column B	Column D
1	60	4359
2	10	45132
3	10	'4324
4	10	1324
5	10	5123
6	60	'4359
7	10	06471
8	10	12345
9	60	'4359
10	10	53121
11	60	4359
12	10	'5123
13	10	512323
14	60	4359

<tbody>
</tbody>

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