=IFERROR(VLOOKUP(A7,Reports!$A$1:$V$1000,6,FALSE) ,"")

If you're getting a result of 0 it means either the corresponding cell in
the table_array is empty or is numeric 0.

If the value returned by the lookup is supposed to be a text value you can
do this:

=IFERROR(T(VLOOKUP(A7,Reports!$A$1:$V$1000,6,0))," ")

--
Biff
Microsoft Excel MVP


"Tina Hudson" wrote in message
...
Good day,

I'm getting a 0 (zero) when I use the following IFERROR statement in Excel
2007:

=IFERROR(VLOOKUP(A7,Reports!$A$1:$V$1000,6,FALSE), "")

I originally used just the VLookup Function, but when the reference cell
(A7) was blank, I got a #N/A error. So, I added the IFERROR function.
Now
I'm getting a 0 (zero) as my result.

I'm confused because I've used this exact expression throughout the
worksheet and didn't have any trouble, except for 2 fields - one a number
field (which I sort of get, but not really) and the other field a text
field.

I tried changing to the following, but I get "False" as the result:

=IF(IFERROR(VLOOKUP(A7,Reports!$A$1:$V$1000,6,FALS E),""),IF(VLOOKUP(A7,Reports!$A$1:$V$1000,6,FALSE) =0,"",(VLOOKUP(A7,Reports!$A$1:$V$1000,6,FALSE))) )

Any help will be most appreciated!
--
Thanks,
Tina Hudson