Iferror vlookup

[chris.slater]

Hi Everyone,
I'm trying to write a VLOOKUP formula but am having some problems with the data it's returning.
I have managed to get around the "#N/A" issue using "IF(ISERROR)" but now have a new problem.
What I need my formula to do is as follows:
Search for a Value in Column A of the 1st worksheet in the array A:F of the 2nd worksheet (entitled'24 Apr 2012') and return the value in Column 6 of that array.
If the value in Column A does not exist with the array then return a BLANK value.
So far so good. The problem arises when the value in column A does exist but the value in Column 6 of the array is actually blank. What the formula is then doing is returning a "0" rather than a BLANK value and this is messing up my results.
Does anyone know how I can change my formula to return a BLANK rather than a zero. The actual formula is below:
=IF(ISERROR(VLOOKUP($A2,'24 Apr 2012'!$A:$F,6,FALSE)),"",VLOOKUP($A2,'24 Apr 2012'!$A:$F,6,FALSE))

[vlady]

hello can't you use index and match??

=IFERROR(INDEX('24 Apr 2012'!$A:$F,MATCH($A2,'24 Apr 2012'!$A:$F),6),"")

[Paul]

I think that still returns a 0, but I could be mistaken. (It did on my sample sheet.)

A VLOOKUP alternative could be:

=IF(VLOOKUP($A2,'24 Apr 2012'!$A:$F,6,0)="","",IFERROR(VLOOKUP($A2,'24 Apr 2012'!$A:$F,6,0),""))

Also, you could just choose to hide zeros on your worksheet in Excel Options.