# 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

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.

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.

4. ## Re: Using If formula with two worksheets

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

5. ## Re: Using If formula with two worksheets

Thanks, that worked.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1