T
Tina Hudson
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,FALSE),""),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!
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,FALSE),""),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!