selecting cell content based on value

**Beanymonster** · 02-05-2007, 11:28 AM

Hi,
Is it possible to auto copy values from a cell if an adjacent cell has a value entered?

e.g. if there is a value in cell B3, is it possible to check for this and if its true, copy the contents of cells A3 and B3 into F5 and G5?

hope that makes sense.
thanks in advance

**oldchippy** · 02-05-2007, 11:49 AM

If B3 =5, then in F3

=IF(B3=5,A3) and in G3

=IF(B3=5,B3)

**Beanymonster** · 02-05-2007, 12:29 PM

thanks - easy when you know how!

is there a way of doing this with the value in B3 being unknown?
For example, being either true (i.e. a number is in the cell) or false (i.e. the cell is empty) and then copying the data accordingly?

**oldchippy** · 02-05-2007, 05:13 PM

Yes, just edit the formula B3=<0 this will only pick up negative numbers, or B3="" if the cell has nothing in it at all.

Hope this is what you want?