Hi! I hope someone can help me with this. I have a worksheet where the
summary sheet pulls info from another 15 worksheets, and we were having
trouble getting the #N/A errors to hide when data wasn't entered into
the cells.

I found a formula that works, and I just need to know how to add it to
the entire sheet, especially since the other cells already contain the
original formula.


Here is an example of what the formula was like befo

=VLOOKUP('VP Summary'!A2,'Air Products'!$A$2:$C$28,3,FALSE)

This is what I had when I managed to add the other formula, and what I
need to do to the several hundred remaining cells:

=IF(ISNA(VLOOKUP('VP Summary'!A2,'Air
Products'!$A$2:$C$28,3,FALSE)),"",VLOOKUP('VP Summary'!A2,'Air
Products'!$A$2:$C$28,3,FALSE))

Any assistance would be greatly appreciated.

Theresa




--
T. Spina