You can actually use ISERROR to cover all the error values:
=IF(ISERROR(Sheet1!A1),"",Sheet1!A1)

-Simon

"David Biddulph" wrote:

"Brento" wrote in
message ...

HI,

I have 2 work sheets in a file, The first sheet contains a table with
names in the first column and a formula in the second and third
columns. which either only show REF or N/A until another value is
entered and become a word value.

On the second sheet I am trying to I am trying to display the same
table as the first sheet but only have the rows with the word values in
and not N/A or REF?

Can this be done? Your urgent help is needed?

=IF(OR(ISERR(Sheet1!A1),ISNA(Sheet1!A1)),"",Sheet1 !A1)
--
David Biddulph