ADVERTISEMENT
scobad said:Now - it returns a BLANK?
When I sum that row, a few columns over - It returns #VALUE
That is whay I was thinking of puting a ZERO in there?
scobad said:Formula: =VLOOKUP(E2:E9000,Taken10!$A2:$H$900,7,FALSE)
If it is #N/A
I would like it to return o (zero)
I am trying to sum ytd hours for a earning. and The N/A is messing me up
scobad said:I like this - but...it does not return 0
=IF(ISNA(VLOOKUP(E2,Taken10!$A2:$H$900,7,FALSE)),"0",VLOOKUP(E2,Taken10!$A2:$H$900,7,FALSE))
I would like that cell to actual have a ZERO in it? then my sum across would work?