Hi ,
After giving vlookup formula my “False” value comes as “0” if the data is not found IN TABLE
I need that to be as “BLANK” can you please advice.
Thanks and regards,
Shradha
Hi ,
After giving vlookup formula my “False” value comes as “0” if the data is not found IN TABLE
I need that to be as “BLANK” can you please advice.
Thanks and regards,
Shradha
Please post your formula.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
try :
Formula:Please Login or Register to view this content.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Try IFERROR formula:
=IFERROR(VLOOKUP(C1,M4:N8,2,FALSE),"")
Click on star (*) below if this helps
Hi all,
I m not asking to replace "#N/A" to "Blank".
I want to replace "0" with "Blank".
The result is zero because in table array for that particular "lookup value “the result is zero.
My formula
=VLOOKUP(U2,Data!C:D,2,0)
For 387710 and 168087 the result comes as “0”. But I want that as “Blank”
Table
C D
Account# CC
189660 harmala
371271 dilipk
371417 dilipk
387710
168087
371519 dilipk
Thanks and regards,
Shradha
Please Login or Register to view this content.
Wow
Why i couldnt think about it
Yes it is working fine
Thank you so very much
Since you are returning text values you can use:
=VLOOKUP(U2,Data!C:D,2,0)&""
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks