I would like data to be displayed in a different cell.
e.g. formula would be in a cell in sheet2, but saying something like, if
sheet1 A10, then print the data from sheet1 C1 into sheet1 D1.

Reason behind using sheet 2 for the formula, is that when i use the formula
in sheet 1 and copy down, the query I'm using for mail merge looks at the
formula data and thinks it is relevant data for importing.
Hope this makes sense to someone.
Thanks
JS