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