Martin

=IF(ISNA(VLOOKUP(CD18, $Q$7:$R$26, 2,FALSE)),"scr",VLOOKUP(CD18, $Q$7:$R$26,
2,FALSE))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Martin Wheeler" wrote in message
...
xl2003
I am getting the above in cells that are either blank or refering to a
cell that has alpahbetical data in it rather than numbers
My spreadsheet contains a table a data and then tables of formulas that
work the data. It is the data of formulas that are the problem
What I want is to have blank cells

I am using =IF(ISERROR(SUM((G20-F20)/F20)),"",SUM((G20-F20)/F20))
successfully in the empty cells that are part of the data table. But get
#N/A in the following =VLOOKUP(CD18, $Q$7:$R$26, 2,FALSE) when the
corresponding data cell has "scr" in it instead of a number. I need to
leave "Scr" in


I am also getting #Value! when using =SUM(CW17-CW16).

I have tried using =If(Iserror..... but am not getting anywhere.

Any help would be greatly apprciaed.
Ta,
Martin