Assistance needed with copying field to different places in Excel

[FLHawkI]

I have an Excel Spreadsheet with the following: Date contained in cell A2 and a drop down list in Cell E2. There are 3 possible selections in Cell E2 - Text1, Text2, Text3. If Text1 is selected I want the date in Cell A2 to be copied to Cell H4. If Cell E2 has Text2 selected the date in Cell A2 Copied to H5. If Cell E2has Text3 selected the date in Cell A2 to copy to Cell H6. I keep getting circular reference when I try to use an if statement. For example in cell h4 put IF(E2="Text1",A2, leave the date in the cell alone). Then in cell H5 I tried to put =IF(E2="Text2",A2,leave the date in the cell alone). Circular reference. I hope someone can help?

 

[BigBeachBananas]

Book2
	A	B	C	D	E	F	G	H
1
2	10/6/23				Text3
3
4
5
6								10/6/23
Sheet2

Cell Formulas
Range	Formula
A2	A2	=TODAY()
H4	H4	=IF(E2="Text1",A2,"")
H5	H5	=IF(E2="Text2",A2,"")
H6	H6	=IF(E2="Text3",A2,"")

Cells with Data Validation
Cell	Allow	Criteria
E2	List	Text1,Text2,Text3

 

[FLHawkI]

When I try the if statements you recommended - I receive a "you can NOT have a CIRCULAR REFERENCE". I already tried that and it does not work.

 

[BigBeachBananas]

When I try the if statements you recommended - I receive a "you can NOT have a CIRCULAR REFERENCE". I already tried that and it does not work.

What is the source of your E2 list validation?

Also go to the Formula tab, and look for error checking -> circular references. These cells might not be the cause, but different cells.

 

[FLHawkI]

 

[FLHawkI]

What is the source of your E2 list validation? - A tab with the text fields in it.

 

[BigBeachBananas]

What is the source of your E2 list validation? - A tab with the text fields in it.

go to the Formula tab, and look for error checking -> circular references. It should show you the cells that are causing the error. Confirm that these cells were not the cause.

 

[FLHawkI]

They are the cause. The circular reference is the A2.

 

[FLHawkI]

If I put one if statement on the spreadsheet it works. It does not work with a second if statement!

 

[BigBeachBananas]

They are the cause. The circular reference is the A2.

Can you share your workbook via DropBox?