Hi KDD,

Just a wild guess: wouldn't the following formula do the trick without a
need for row [5 ]and column [C]:

=IF(J19=0,0,INDEX($D$6:$K$10,MATCH(I19,$B$6:$B$10) , MATCH(J19,$D$4:$K$4)))

Regards,
KL


"KDD" wrote in message
...
Thanks Guys - i got the solution:

This works::

=IF(J32=0,0,INDEX($D$6:$K$10,VLOOKUP(I32,$B$6:$C$1 0,2),HLOOKUP(J32,$D$4:$K$5,2)))

cheers and tx for your help. As always, thsi is the best place to come for
help on excel!
--
KDDXB


"KDD" wrote:

Hi Dave i dint understand your sugggstion

I19 is a dependant cell of J19, but i want to ensure K19 doesnt return
#N/A
when J19=0.

pls help



--
KDDXB


"Dave Peterson" wrote:

Maybe just check for i19 first.

=if(i19="","",index(....))

I showed "", but you could use any thing you wanted.

KDD wrote:

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

--

Dave Peterson