Not sure of formula help please

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

If I enter in cell A1 text 'BT1' I would like the text Bob Todd to appear in
cell A2. If I enter 'BT2' in A2 I would like text Bob Todd to appear in
cell A2. Is this possible could someone help me with the formula please.

Thank you

Mark
 
If I enter 'BT2' in A2 I would like text Bob Todd to appear in
cell A2. Is this possible could someone help me with the formula please.
Click to expand...

There is no worksheet formula that can cause a cell to overwrite
itself. Either you made a mistake in describing what you want, or
you'd have to use a VBA macro that's triggered by the Change event.
 
Sorry Stan you are correct I meant if I enter BT2 in A1 (with the number
part variable) it enters Bob Todd in A2

Thanks

Mark

PS how's the snow?
 
Hi Mark,

Am Sat, 9 Feb 2013 18:40:07 -0000 schrieb Mark:
Sorry Stan you are correct I meant if I enter BT2 in A1 (with the number
part variable) it enters Bob Todd in A2
Click to expand...

in A2 try:
=IF(OR(A1={"BT1","BT2"}),"Bob Todd","")


Regards
Claus Busch
 
Back
Top