Populate Cell from one of several cells

[Loin75]

Hi All,

In my worksheet1, Cell A1 is my Age.

It's formula is =worksheet2!A1 (ie, I enetered my Age in Cell A1 on sheet 2 and it was pulled through.

I want to be able to put my Age in worksheet3!A1 aswell, and have sheet1 populate just the same...

Hope this makes sense..
Is this possible please?

Many Thanks

 

[CoastalPhil]

How is the cell on worksheet1 to decide whether to use the value on sheet 2 or sheet 3?

 

[Loin75]

Thats my question...

I want it to accept a value from either of the other cells, whichever is filled.

Note - Only one will be filled, so there won't be conflicitng info trying to populate the cell.

Is it possible?

 

[CoastalPhil]

Yes!

=if(Worksheet2!A1="",Worksheet3!A1,Worksheet2!A1)

Basically says if A1 in sheet 2 is blank, then use A1 in sheet 3, otherwise (ie if A1 in sheet 2 is filled) then use A1 in sheet 2.

 

[Loin75]

Perfect and simple!!

Many thanks CoastalPhil...