I have a formula that needs to return blanks as blank and 0s as 0. The vlookup formula will return blanks as 0, or I can make it return a blank whenever it is zero (below), but some cells may have a 0 record that need to return 0s, not blank.
Right now I am missing a few records that are entered as "0". I have:
=IFERROR(IF(VLOOKUP(O16,'Sheet1'!$A:$Z,8,FALSE)=0,"",VLOOKUP(O16,'Sheet1'!$A:$Z,8,FALSE)),"")
any ideas?
you could try
iferror(--(VLOOKUP(O17,Sheet1!$A:$Z,8,FALSE)&""),"")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
hey that works well, except it does not show any records with text. can you please explain the "--"
=IF(ISBLANK(VLOOKUP(O16,'Sheet1'!$A:$Z,8,FALSE)),"",VLOOKUP(O16,'Sheet1'!$A:$Z,8,FALSE))
That should do the job.
Say thanks, click *
harribone. worked great i added iferror around it as well. thanks
No probs, don't forget to mark thread solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks