Hi,
I have two workbooks open at the same time.

I would like to have a simple IF statement that checks whether cells match on both workbooks.

Ideally, it would work similar to this (which doesn't work BTW):

Sub blah_blah=blah()
If Range(Range("WORKBOOK_1_NAME").Value & "Sheet1!A1").Value = Range("NAMED_RANGE_1").Value Then
MsgBox "Match"
Else
MsgBox "No Match"
End If
End Sub
Is there is a way to modify the IF statement so that the WORKBOOK_1_NAME & range work? If it's not possible, what would be the easiest way to accomplish it?

Thanks in advance!