hlookup work if exists

Hi, first of all, I would like to thank all of you for helping me so much throughout the weeks I have been on here and would really like to say slowly but surely I am learning excel.

I have a sample workbook I will put at the end, but I need someway for hlookup to work overall even if one of the hlookups doesn't.

IE (this is from the sample workbook): =HLOOKUP("A",Sheet2!A1:C1,2,0)+HLOOKUP("A",Sheet3!A1:C3,2,0)+HLOOKUP("A",Sheet4!A1:C3,2,0).

If "A" isn't in one of the sheets no matter what it will return #N/A. Is there some way (I'm sure there is) for me to make these #N/A hlookups just act as zero?

Hi,
Try the following. it checks to see if each term is an error, and if so returns 0, else it evaluates the Hlookup


=IF(ISERROR(HLOOKUP("A",Sheet2!A1:C1,2,0)),0,HLOOKUP("A",Sheet2!A1:C1,2,0))+IF(ISERROR(HLOOKUP("A",Sheet3!A1:C3,2,0)),0,HLOOKUP("A",Sheet3!A1:C3,2,0))+IF(ISERROR(HLOOKUP("A",Sheet4!A1:C3,2,0)),0,HLOOKUP("A",Sheet4!A1:C3,2,0))