| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Not sure of formula help please
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Not sure of formula help please
On Sat, 9 Feb 2013 17:36:50 -0000, Mark wrote:
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. 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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Not sure of formula help please
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? "Stan Brown" wrote in message t... On Sat, 9 Feb 2013 17:36:50 -0000, Mark wrote: 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. 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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Not sure of formula help please
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 in A2 try: =IF(OR(A1={"BT1","BT2"}),"Bob Todd","") Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Not sure of formula help please
Many thanks Claus great help it works! Thank you
Mark "Claus Busch" wrote in message ... 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 in A2 try: =IF(OR(A1={"BT1","BT2"}),"Bob Todd","") Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula autofill to cells below – formula arguments are cell areas in different columns | Excel Discussion (Misc queries) | |||
| Build formula using field values as text in the formula referencing another workbook | Links and Linking in Excel | |||
| Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
![Mark[_70_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
