In Main sheet C76 enter

=IF(Sheet2!C76="2N","S","")


Gord Dibben MS Excel MVP

On Sun, 2 Dec 2007 15:02:01 -0800, Dave wrote:

i have a workbook containing 3 sheets sheet one is my main one the other two
are for reference , on sheet two i have a data entry of "2N" in cell C76. i
want to shoe this data entry on to my main sheet in exactly the same cell
location C76, but i want the entry to say "S" instead of "2N".
at the moment i have managed to get the Cells to link up using the 3D
function it's the conversion i have trouble with?
can any body give me some idea or direction.
cheers