#N/A - - Can someo help me get this fixed?

[scobad]

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

 

[Richard Schollar]

=IF(ISNA(VLOOKUP(E2,Taken10!$A2:$H$900,7,FALSE)),"",VLOOKUP(E2,Taken10!$A2:$H$900,7,FALSE))

Best regards

Richard

Edit: I noticed you were using a range (E2:E900) rather than a single cell, so I modified the Vlookup

 

[scobad]

Almost

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?

 

[crobertson]

Try this

=IF(ISNA(VLOOKUP(E2,Taken10!$A2:$H$900,7,FALSE)),"0",VLOOKUP(E2,Taken10!$A2:$H$900,7,FALSE))


Let me know if this helps!

 

[Brian from Maui]

Re: Almost

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?

To sum with #N/A in your range

=SUMIF(A1:A10,"<>#N/A")

 

[Aladin Akyurek]

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

Keep the results of

=VLOOKUP(E2,Taken10!$A$2:$H$900,7,0)

as is if you can and invoke:

=SUMIF(Range,"<>#N/A")

for summing, a setup that is a lot cheaper.

 

[scobad]

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?

 

[Brian from Maui]

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?

Remove the ""

See,

http://www.mrexcel.com/board2/viewtopic.php?t=62102

 

[scobad]

As I copied this down - All the ones that had values are gone:

So - In Column N I would like to report a ZERO if is unfound
Than I can sum the ROW..

 

[scobad]

=IF(ISNA(VLOOKUP(E2,Taken10!$A2:$H$900,7,FALSE)),"0",VLOOKUP(E2,Taken10!$A2:$H$900,7,FALSE))


That is what I am using....Not working...