Is an IF statement the correct way to go here
I have 2 worksheets that I'm working on. I simply want to say if Sheet1 column
C has the word ORANGES I want to return that rows values to sheet2.
Example below of what to look like
Now the other amateur question would be is there a way for it to be done so it does not
return the false value.

Sheet1

A B C
Test1 JAMES APPLES
Test2 JOHN ORANGES
Test3 DEAN PEARS

Sheet2

A B C
FALSE FALSE FALSE
Test2 JOHN ORANGES
FALSE FALSE FALSE


=IF(Sheet1!C2="ORANGES",Sheet1!A2:B2)