Try it this way..........

=if(isna(LOOKUP($H13,$H$48:$I$98,$G$48:$G$98)),"", (LOOKUP($H13,$H$48:$I$98,$G$48:$G$98))


Vaya con Dios,
Chuck, CABGx3



"The Toasterman" wrote:

Nope, doesn't like that. The formula in the cell is a lookup

=if(isna(=LOOKUP($H13,$H$48:$I$98,$G$48:$G$98)),"" ,(=LOOKUP($H13,$H$48:$I$98,$G$48:$G$98))

Doesn't want to close the formula.

???

"CLR" wrote:


The #N/A error is usually the result of a formula..........try wrapping that
formula in an IF statement, like......

=IF(ISNA(YourFormula),"",YourFormula)

Vaya con Dios,
Chuck, CABGx3




"The Toasterman" wrote:

A spreadsheet I am working on return #n/a into a cell as it only dins a blank
in the validation menu we are using.

Is there any way to get excel to ignore #n/a & show a blank?