Basic IF statement query

[Rizzo12]

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)

[Sam Capricci]

it appears you want a formula that will look up a value. If the value would be to the right of your value (oranges) you could use a vlookup, since it is to the left you would need an index/match.
like this =INDEX(sheet1a:a,MATCH("oranges",sheet1c:c,0)) as a guess.

[pjwhitfield]

you need to put what you want displayed if its false

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

Your formula however wont return B2 it only returns A2 into the cell, if you want both to be displayed in the cell then put Sheet1!A2 & Sheet1!B2

[Sam Capricci]

as a help, to deconstruct the formula, the first part =INDEX(sheet1a:a is saying this is the location for the value you want returned, the next part MATCH("oranges",sheet1c:c,0)) is saying that you want oranges (or the equivalent cell in sheet2 to be found in that area of sheet1 c:c and the 0 is saying give me an exact match.

EDIT: and my assumption is based on the possibility that you won't have the exact same order between the two sheets. An if/then stmt will assume that your values in row 1 of sheet 1 will match the values in row 1 of sheet 2, if something else is there but your value is in row 2 then you will have problems.