Hi all,

I need to use a formula to pick up text from another workbook.

I did use the conventional = but this just seems to return '#value' in my
desired cell.

I trust I need to do something slightly more complicated but am at a loss as
to what.

Any help would be greatly appreciated.

Many thanks in advance.

Ant