Ignoring Blank Cells In IF Statement

[BBar]

I have a new dilemma: I THINK I figured out how to get rows to copy from column information from one workbook to another but now when I do this: See Screeshot Capture 4.jpg
I have a lot of FALSE rows in the workbook.
This is the formula I'm currently using: =IF('[MASTER WIP.xlsx]3.9.13'!$N$6:$N$107="X",'[MASTER WIP.xlsx]3.9.13'!$A$6:$A$107)

How can I get the rows that have a blank cell in the column I'm getting the information from to not copy/transfer ... I mean, is there a way to sort of Skip or Ignore if the cell in the column is left blank?

Maybe because when I used the IF Function I entered a Logical Test and Value if Ture but I left Value if False Blank?

[tgsekhar]

The construct of IF Condition is given below:
IF(Condition, Value if Condition evaluates to True, Value if Condition evaluates to False)
In your formula Condition and TrueValues are given. Introduce a FalseValue as "" (Blank Text)

Please Login or Register  to view this content.