IF(ISNA(IF(AND Statement

Could someone please help me fix this formula so if #N/A shows up, it leaves the cell blank?

=IF(AND($S$1:$S$10000>" ",VLOOKUP(S:S,'Contact Information'!B:L,11,FALSE)<>""),VLOOKUP(S:S,'Contact Information'!B:L,11,FALSE),"")

Thank you!

Hi freybe06

try it

=if(ISNA(IF(AND($S$1:$S$10000>" ",VLOOKUP(S:S,'Contact Information'!B:L,11,FALSE)<>""),VLOOKUP(S:S,'Contact Information'!B:L,11,FALSE),"")=TRUE,"",IF(AND($S$1:$S$10000>" ",VLOOKUP(S:S,'Contact Information'!B:L,11,FALSE)<>""),VLOOKUP(S:S,'Contact Information'!B:L,11,FALSE),""))

Isn't this same thread?

http://www.excelforum.com/excel-work...k-problem.html

zbor - that looks similar but that person was getting a #value error, not a #n/a.

Azam - I'm getting an error in that stops me up to this point:

=if(ISNA(IF(AND($S$1:$S$10000>" ",VLOOKUP(S:S,'Contact Information'!B:L,11,FALSE)<>""),VLOOKUP(S:S,'Contact Information'!B:L,11,FALSE),"")=TRUE,""

When I insert a close perenthesis, I get a too many arguments error.

try that solution 'cause it should work.. here is:

=IF(ISERROR(1/VLOOKUP(S1,'Contact Information'!$B$1:$L$22,11,FALSE)),"",VLOOKUP(S1,'Contact Information'!$B$1:$L$22,11,FALSE))

It looks like this formula is working for numbers fields, but not for text fields.

That works perfectly. Thanks again NBVC!

Thanks Azam and zbor as well. I appreciate you all taking the time to help!

I may have spoken too soon... haha

If S1 does contain something, then the VLOOKUP is blank, the cell shows up as "0" - is there a way to make it so the cell shows a blank if there is nothing for the VLOOKUP to return?

Thanks!