LinkBack URL
About LinkBacks
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!
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
Never use Merged Cells in Excel
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.
How about?
Please Login or Register to view this content.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
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!
The easiest way to avoid mega formulas... is to format the result cells as Number:Custom and enter 0;-0;;@
this hides 0 results.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks