Claris,

what exactly do you want your formula/macro to return? The workbook in
which the value is found? A sheet name? An address? A value next to the
found item?

Kostis Vezerides