LinkBack URL
About LinkBacks
i have multiple lookup with other files, if no data in that columns then display "0" in few cells. i want blank result. how to hide 0? already i hide #N/A
i have multiple lookup with other files, if no data in that columns then display "0" in few cells. i want blank result. how to hide 0? already i hide #N/A
Please Login or Register to view this content.
Add this in front or end? I have very long formula..with multiple lookup
HOW TO I ADD IN THIS FORMULA?Please Login or Register to view this content.
try this one.
add this & "" to every end of the vlookup.
=IFERROR(IFERROR(VLOOKUP(I7456,'[( VINO ) MAY MONTH LOGIN SHEET 2013.xlsx]Login Sheet'!$I:$AC,21,0) & "",,the next vlookup..............
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
I had a buddy who had this problem, you may have better luck using "FALSE" instead of "0" in your VLOOKUP formula.
when i be in officei will try all the above options, now am at home. Hai casalukis, pls explain how to insert false function in my formula? Give some example
in your vlookup, the last input you have 0, you can put false there instead and it may solve your issue.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks