A1 change into C1 only if E1 is True.

[spiceytayley]

Hello. I'm trying to create a formula in excel that will make A1 change into C1 only if E1 is True.
If E1 is false, I need the cell in A1 to remain as is.
(I'm trying to get this to happen without adding another column with the same values as originally located in column A).
Any assistance would be greatly appreciated.
Thank You <3

U

77

B

2402

TRUE

EX: The above "U" should change into the "B" because it is marked as "TRUE"

B

72

C

2264

FALSE

EX: The above "B" should remain the same ("B") as it is marked "FALSE".

This is the data that I'm working with:

B	12	B	216	FALSE
B	13	B	308	TRUE
B	14	B	434	FALSE
B	38	B	1061	TRUE
M	39	B	1126	FALSE
U	77	B	2402	TRUE
B	78	B	2414	FALSE
B	118	B	3477	FALSE
U	119	B	3492	TRUE
B	124	B	3631	FALSE
U	151	B	4483	TRUE
M	152	B	4515	FALSE
M	162	B	4769	FALSE
U	163	B	4784	TRUE
B	164	B	4825	FALSE

[Heyjoe]

Spiceytaley
A few questions
1) Is the reason you don't want to add a column because you don't want to change how your worksheet looks? If so you could have a data entry column where you enter the values that you have in column A, then you could hide it easily hide it using the group command under the data menu. You could then enter formulas in Column A that reference you data entry column.
2) Another option would be to enter all of your data that you show in workbook 1. Then have formulas in worksheet 2 that will change the what is in column A.
3) Another option would be a code solution.

Would any of this 3 solutions work for you?

[Pecoflyer]

Please post a sample sheet so we can work with it
Click Go advanced - Manage attachments and follow the wizard. Thanks

[spiceytayley]

Maybe a code solution?
We are just trying to make it happen without adding extra data to the mix.
I've attached a sheet.Formula Inquiry.xlsx

[Heyjoe]

Maybe a code solution?
We are just trying to make it happen without adding extra data to the mix.
I've attached a sheet.Formula Inquiry.xlsx

Public Sub mysub()
Sheets("sheet1").Select
Dim rng As Range, cell As Range


Set rng = Range("a1:a200")


For Each cell In rng
    If cell.Offset(0, 4).Value = True Then
    cell.Value = cell.Offset(0, 2).Value
    End If
Next


End Sub

[Pecoflyer]

Please don't quote whole posts -- it's just clutter and makes the thread hard to read. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding
For normal conversational replies, try using the QUICK REPLY box below.