Vlookup returning a blank cell

[dhally]

Hello;
I have viewed numerous threads regarding: Vlookup returning a blank cell if is lookup returns #NA.

Yet, when I use the the accepted formula format given on many different websites I get a return of a number zero when I really want a return of a blank cell. Here is my original Vlookup formula:
=VLOOKUP(A300,'VLOOKUP_FOR_BLANK_RANTALA_Request For SAP Upload Form.xlsx'!LookupContainer,12,FALSE)

Here is the formula I had hoped would return a blank cell:
=IF(ISNA(VLOOKUP(A301,'VLOOKUP CONTAINER'!K301:L301,2)),"",(VLOOKUP(A301,'VLOOKUP CONTAINER'!K301:L301,2))

Any help would be very appreciated. Thank you in advance
dh

 

[T. Valko]

It works perfect.

I can't tell you how many threads I viewed on this particular "vlookup..return blank cell value". I Saw plenty of the IFERROR(Vlookup...) but
and none of them showed the "T" (text) portion of the formula syntax as yours which of course did the trick.

This is why I didn't sign up to post on any other sites except Mr. Excels question board!

Very happy and many grateful thank you's,
dh

Glad it helped you out. Thanks for the feedback!

Think outside the box!

 

[dhally]

One more question T. Valko,
The "T" value in the formula works fine when text is present but numbers don't show up numbers are present.

 

[MrKowz]

Try:

=IFERROR(IF(VLOOKUP(A301,'VLOOKUP CONTAINER'!K301:L301,2,0)="","",VLOOKUP(A301,'VLOOKUP CONTAINER'!K301:L301,2,0)),"")

 

[T. Valko]

One more question T. Valko,
The "T" value in the formula works fine when text is present but numbers don't show up numbers are present.

If the returned value can be either text or numbers then use this version:

=IFERROR(IF(VLOOKUP(A301,'VLOOKUP CONTAINER'!K301:L301,2,0)="","",VLOOKUP(A301,'VLOOKUP CONTAINER'!K301:L301,2,0)),"")

 

[dhally]

Most excellent! This site is great and very patient with noobies like mylelf.

dh

 

[dhally]

jonmo1,
I'd send you an attachment of on the one row array if I could.
dh

 

[Jonmo1]

jonmo1,
I'd send you an attachment of on the one row array if I could.
dh

Sure, I'd like to see it.
I PM'd you my email

 

[Aladin Akyurek]

Hello;
I have viewed numerous threads regarding: Vlookup returning a blank cell if is lookup returns #NA.

Yet, when I use the the accepted formula format given on many different websites I get a return of a number zero when I really want a return of a blank cell. Here is my original Vlookup formula:
=VLOOKUP(A300,'VLOOKUP_FOR_BLANK_RANTALA_Request For SAP Upload Form.xlsx'!LookupContainer,12,FALSE)

Here is the formula I had hoped would return a blank cell:
=IF(ISNA(VLOOKUP(A301,'VLOOKUP CONTAINER'!K301:L301,2)),"",(VLOOKUP(A301,'VLOOKUP CONTAINER'!K301:L301,2))

Any help would be very appreciated. Thank you in advance
dh

If you have many instances to check...

=IFERROR(IF(V(VLOOKUP(A301,'VLOOKUP CONTAINER'!K301:L301,2,0))="","",V()),"")

where V() is a function in VBA that you can add to your workbook as a module:

Public Function V(Optional vrnt As Variant) As Variant
'
' Stephen Dunn
' 2002-09-12
'
Static vrntV As Variant
If Not IsMissing(vrnt) Then vrntV = vrnt
V = vrntV
End Function

 

[dhally]

I'm new to posting on this site (today actually)....PM'd ???

 

[Jonmo1]

I'm new to posting on this site (today actually)....PM'd ???

PM = Private Message

Up on top right area of forum, where it says
Welcome dhally

There's a link for
Your Notifications