How to use if then to compare values in 2 different worksheets

[status1]

Hello,
I am looking for a formula or expression that will compare 2 cells in different worksheets so that I can copy the cells from the second sheet to a third sheet to a location based on the result of the comparison

So I have Sheet1 with 4 rows and the cells to compare are in B2 to B5 On Sheet2 I have 2 rows where values in B2-B3 will match one of the values on sheet 1

I am trying to keep it simple so I want to use in the macro something like IF Sheet2 B2 = Sheet1 B2 THAN do something

I am just not sure how to use the expression to give me what I want

[6StringJazzer]

It is not clear from your description if you want a formula or a macro. You mention both.

to a third sheet to a location based on the result of the comparison

Can you be more specific? How do you determine the location on the third sheet?

[status1]

Sorry that would be for a VBA macro

Once I have the formula or expression working than I can continue to use the macro to copy and paste from sheet2 to another sheet
The main thing is to get the formula working
I tried something like this

If CLOSE1!B2 = OPEN1!B2 Then GoTo SKIP

but I am getting an error runtime error424 object required which I don't know what it means

[status1]

After trying a bunch of different things I found a solution
After selecting the CLOSE1 sheet and the range to B2 I can use the formula

If Range("B2").Value = Sheets("OPEN").Range("B2").Value Then GoTo

[6StringJazzer]

Thread moved from Excel General.