kuldeepjainesl
Member
Hello All,
i am searching a way to check whether my Range values (D1:D25) are matching to the values available in same row for range A1:C100
Requirement is to pick each value from D1:D25 and check it in A1:C1 and if any value get match, it should give "True" in coloum "E" and this is to be done for for Each Row.
I am ok with both the potion "Formula or VBA".
Below mentioned piece i found on internet does the job but it provide the answer in multiple coloum due to this statement
.i need all the True in coloum E
i am searching a way to check whether my Range values (D1:D25) are matching to the values available in same row for range A1:C100
Requirement is to pick each value from D1:D25 and check it in A1:C1 and if any value get match, it should give "True" in coloum "E" and this is to be done for for Each Row.
I am ok with both the potion "Formula or VBA".
Below mentioned piece i found on internet does the job but it provide the answer in multiple coloum due to this statement
Code:
ThisCell1.Offset(, 1).Value = "TRUE"
Code:
Dim ThisCell1 As Range
Dim ThisCell2 As Range
For Each ThisCell1 In Range("A1:C100")
'This is the range of cells to check
For Each ThisCell2 In Range("D1:D25")
'This is the range of cells to compare
If ThisCell1.Value = ThisCell2.Value Then
ThisCell1.Offset(, 1).Value = "TRUE"
Exit For
End If
Next ThisCell2
Next ThisCell1