It will be a great help if someone could guide me to do the following:
1. compare the Server Name and Serial Number values in Sheet 1 to the same in Sheet 2 and viceversa.
2. If values match populate the Machine Class column of the Sheet 1 with the Machine Class value from the Sheet 2 of the values found to be matching.
I have tried vlookup and a macro which actually helped me a bit to find the still no luck :'(
=VLOOKUP(A2,$B$2:$B$121,1,FALSE)
and
=VLOOKUP(B2,$A$2:$A$92,1,FALSE)
Where I had the Server names from Sheet 1 and Sheet 2 in columns A and B. However, this also didnt solve my problem.
I have Used this macro tryin to match:
Sub Find_Matches()
Dim RangeA As Variant, RangeB As Variant, x As Variant, y As Variant
Set RangeB = Range("H1:H92")
Set RangeA = Range("J1:J122")
For Each x In RangeA
For Each y In RangeB
If x = y Then y.Offset(0, 1) = x
If y = x Then y.Offset(0, 1) = y
Next y
Next x
End Sub
However, wasn't successful :'(
Please do help...
Bookmarks