I am trying to do a vlookup where it brings back a blank cell when it brings back 0 and N/A?
I got this far
=IF(LEN(VLOOKUP(D22,Sheet6!$A:$J,10,0))=0,"",VLOOKUP(D22,Sheet6!A:J,10,0))
But, then I need the "iferror" function to not bring back n/a.
I am trying to do a vlookup where it brings back a blank cell when it brings back 0 and N/A?
I got this far
=IF(LEN(VLOOKUP(D22,Sheet6!$A:$J,10,0))=0,"",VLOOKUP(D22,Sheet6!A:J,10,0))
But, then I need the "iferror" function to not bring back n/a.
Maybe
=IFERROR(IF(VLOOKUP(D22,Sheet6!A1:J100000,10,0)=0,"",VLOOKUP(D22,Sheet6!A1:J100000,10,0)),"")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
That is it...thank you so much!!!
Here's another approach:
=IFERROR(VLOOKUP(D22,Sheet6!$A:$J,10,0)&"","")
This assumes that the return of 0 is from a matched blank cell.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks