Using If formula with two worksheets

1. Using If formula with two worksheets

Is there a way of using the IF formula to print what is in a cell on a second worksheet if the answer to query on the first worksheet is correct?
ie - in cell B3 asking about A3 and if query is correct printing what is in B3 on second worksheet.

Thanks  Register To Reply

2. Re: Using If formula with two worksheets

We'd need help understanding how the second sheet will know if the query is correct or not, but the comparison is simple enough:

=IF(Sheet1!B3="dog",Sheet1!B3,"")

I'm just showing an example of how you can include the verification of whether the answer is correct or not with "dog". It could also be

=IF(Sheet1!B3=Sheet1!A3,Sheet1!B3,"")

Hopefully you get the idea.  Register To Reply

3. Re: Using If formula with two worksheets

The example I'm trying to use is: In cell B3 (worksheet 2), question , if cell A3 (worksheet 2) is( 1 ) then copy cell B3 from (worksheet 1) in cell B3 (worksheet 2).

Trying to get the data from Worksheet 1 to Worksheet 2 if the query is correct.  Register To Reply

4. Re: Using If formula with two worksheets

=IF(Sheet2!A3=1,Sheet1!B3,"")  Register To Reply

5. Re: Using If formula with two worksheets

Thanks, that worked.  Register To Reply