CLR, there's no change in the formula result. Still showing #N/A.

Just a question: J19 is dependant on I19. I19 is also a formula driven
cell. Does that nullify the effect of your suggestion in my =index(....)
formula?
--
KDDXB


"CLR" wrote:

Try something like replacing your VLOKUP section with........

=IF(I19<0,YourVlookupFormula,0)

Vaya con dios,
Chuck, CABGx3


"KDD" wrote in message
...
How do i use this formula to return 0 without using ISERROR.

=INDEX($D$6:$K$10, VLOOKUP(I19,$B$6:$C$10,2), HLOOKUP(J19,$D$4:$K$5,2))

Problem is, if there is no value in I19, it returns #N/A, which in turn
effects all my other formulae linked to that cell into #N/A.

Pls help. Thank you.
--
KDDXB