How to make cell blank if #N/A

[Excelo]

Hi All,

I have a cells with a formula that references a table, =HLOOKUP($D$6,Benefits,2,FALSE)


Not all cells are used all the time and appear with #N/A. I want to maintain the formula, but if it returns #N/A I want cell to appear blank. If I can do this with conditional formatting that would be great. Then I won't have to change each cell's formula.

Thanks so much for your help.

 

[MrKowz]

Try:

Excel 2003 or older:
=IF(ISERROR(HLOOKUP($D$6,Benefits,2,FALSE)),"",HLOOKUP($D$6,Benefits,2,FALSE))

Excel 2007 or newer:
=IFERROR(HLOOKUP($D$6,Benefits,2,FALSE),"")

 

[Excelo]

Thank You!

Is there a way to make #N/A's blank with conditional formatting? or a way to easily change each formula to =IFERROR(HLOOKUP($D$6,Benefits,2,FALSE),"")?

I already filled majority of worksheet out with just the HLookup