VLOOKUP problem

[TOMCAT1981]

So, I have a guy that wants to populate a sheet, then wants another sheet that copies the info from the first sheet. In Sheet2 the user will fill a column that will use VLOOKUP to enter all data that was entered in Sheet1.

My formula in Sheet2
=IFERROR(VLOOKUP(A5,TABLE,4,FALSE)," ")

The formula works just fine, except if there is no data entered in that column it's calling out, it brings back a 0. How do I get it to be just blank?

 

[AlanY]

try

=if(isblank(A5),"",IFERROR(VLOOKUP(A5,TABLE,4,FALSE)," "))

 

[jtakw]

Hi,

Unless you have an Explicit reason to, Don't use a Space as a result, use "", Not " " (Blank vs. Space).

 

[TOMCAT1981]

try

=if(isblank(A5),"",IFERROR(VLOOKUP(A5,TABLE,4,FALSE)," "))

Still returns a "0" in the cell. Also when VLOOKUP is supposed to bring back a date, if it is blank it shows up as 1/0/1900

 

[AlanY]

could you post a sample of data that didn't work as expected

 

[Fluff]

Maybe
=if(A5="","",IFERROR(VLOOKUP(A5,TABLE,4,FALSE),""))

 

[AlanY]

Still returns a "0" in the cell. Also when VLOOKUP is supposed to bring back a date, if it is blank it shows up as 1/0/1900

ok, try this instead

=IF(ISBLANK(VLOOKUP(A1,TABLE,4,FALSE)),"",VLOOKUP(A1,TABLE,4,FALSE))

 

[SpillerBD]

=IF(VLOOKUP(A5,TABLE,2,FALSE)=0,"",VLOOKUP(A5,TABLE,2,FALSE))

You have to validate the results before accepting it.