"KDD" wrote
I tried this, but still not working. the cell returns #N/A.
Can you suggest an alternative pls?

The suggested error trap
=IF(OR(I19="",J19=""),0, ...)

addressed your orig. post's line:
Problem is, if there is no value in I19, it returns #N/A

(there was an additional check for no value in J19 thrown in as well)

If you still get #N/A, that means it's coming from either the VLOOKUP or the
HLOOKUP (or both)

Try either:

=IF(OR(I19="",J19=""),0,IF(OR(ISNA(VLOOKUP(I19,$B$ 6:$C$10,2)),ISNA(HLOOKUP(J
19,$D$4:$K$5,2))),0,INDEX($D$6:$K$10,VLOOKUP(I19,$ B$6:$C$10,2),HLOOKUP(J19,$
D$4:$K$5,2))))

or:

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

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--