I want to compare a cell value with a cell value in another sheet using vlookup. Isnt it possible to compare Cells with Vlookup in a IF-statement? When I try
MsgBox Cells(ResEnd.Row, rFind.Column)
MsgBox Application.VLookup(9400, ThisWorkbook.Sheets("Sheet1").Columns("F:G"), 2, False)

They return the same value (-453,4). However, even if the values are the same it says "Doesnt match".



If (Cells(ResEnd.Row, rFind.Column) <> Application.VLookup(9400, ThisWorkbook.Sheets("Sheet1").Columns("F:G"), 2, False)) Then

MsgBox "Doesnt match"

End If