Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to do in If then statement using three sheets. Something Like this, If (Cell=Accepted, then this cell is eual to sheet 1, if false then leave blank).

share|improve this question

closed as not a real question by Breakthrough, Diago, Dave M, Diogo, CharlieRB Jan 23 '13 at 20:33

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

5  
Try to describe more of what you are trying to achieve, why should the Accepted cell equal sheet 1, what value or condition from sheet1? –  HaydnWVN Jan 23 '13 at 16:35

1 Answer 1

up vote 0 down vote accepted

Assuming you're putting this into Sheet3 cell A1, then the following will check Sheet2 cell A1 for the value "Accepted" and put the value of Sheet1 cell A1 into the cell, otherwise it will leave it blank.

=if(Sheet2!A1="Accepted",Sheet1!A1,"")
share|improve this answer
    
Thank you So much!!!!!! Exactly what I needed –  user192213 Jan 23 '13 at 18:00
    
hi user192213, welcome to SO! Please don't forget to accept this as an answer - and upvote the answer if it helped you! –  Peter Albert Jan 23 '13 at 19:32
    
Ok another question to that, if =if(Sheet2!A1="Accepted",Sheet1!A1,""), instead of accepted how would I type if I need it to be date only instead of Accepted and it it's a date it goes to sheet 2 and if it's not a date it goes to sheet 3? so if(sheet2!A1="some date",Sheet1!A1,"") –  user192213 Jan 23 '13 at 20:39
    
There's not a function to do that directly in Excel, but there are some ways to "fake" it. Try those, or do some google searches for other methods. If you're still not getting it, try a new question here, but be sure to detail what you've tried and where it's not working. –  techturtle Jan 23 '13 at 21:06
    
I've manipulated it by if it's = "NA" then put in sheet 3 and if <> "NA" then put on sheet 2, but now ran into issue that when using <> it puts 0 in when data is blank? Anyway to fix this? Here's the acutal code... =IF('Master Intake Tracker'!K7 <>"NA",'Master Intake Tracker'!A7,"") –  user192213 Jan 23 '13 at 21:45

Not the answer you're looking for? Browse other questions tagged or ask your own question.