result as "BLANK" instead of "0".

**Shradharani** · 09-07-2012, 09:03 AM

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

**TMS** · 09-07-2012, 09:12 AM

Please post your formula.

**tom1977** · 09-07-2012, 09:14 AM

try :

Formula:

Please Login or Register  to view this content.

**K m** · 09-07-2012, 09:24 AM

Try IFERROR formula:

=IFERROR(VLOOKUP(C1,M4:N8,2,FALSE),"")

**Shradharani** · 09-07-2012, 09:37 AM

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

**tom1977** · 09-07-2012, 09:42 AM

Please Login or Register  to view this content.

**Shradharani** · 09-07-2012, 10:03 AM

Wow
Why i couldnt think about it
Yes it is working fine
Thank you so very much

**Cutter** · 09-07-2012, 07:39 PM

Since you are returning text values you can use:

=VLOOKUP(U2,Data!C:D,2,0)&""

result as "BLANK" instead of "0".

LinkBack

Thread Tools

Rate This Thread

Display

result as "BLANK" instead of "0".

Re: result as "BLANK" instead of "0".

Re: result as "BLANK" instead of "0".

Re: result as "BLANK" instead of "0".

Re: result as "BLANK" instead of "0".

Re: result as "BLANK" instead of "0".

Re: result as "BLANK" instead of "0".

Re: result as "BLANK" instead of "0".

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions