try this. However, it not exist it gets the value from another cell. To use
the value from the SAME cell, you need a UDF macro

=IF(ISERROR(INDIRECT("'joe'!A1")),H1,INDIRECT("joe !A1"))

--
Don Guillett
SalesAid Software

"Smitty" <Smitty @discussions.microsoft.com wrote in message
...
In a worksheet (1) I want to search for the existence of another worksheet
(2). If found, I want to extract the value from that worksheet(2) into a
cell
in the active worksheet (1). If not found I want to default to the value
that
already exists in the cell in the active worksheet (1).