Question description:
This user has given permission to use the problem statement for this
blog.
Hi, I have created a drop down list and in another cell I have used an IF function which is dependent on the drop down list. However, when i change the selected option from the drop down list, the IF function cell does not update accordingly
Solved by C. C. in 17 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
14/06/2018 - 09:57
Hi there!
User
14/06/2018 - 09:57
hi
Excelchat Expert
14/06/2018 - 09:57
I'd love to help you out - is there any way I can take a peek at your file or can you show me the IF formula you have on your sheet?
User
14/06/2018 - 09:58
this is the IF formula
User
14/06/2018 - 09:58
=IF(A1="18/19",INDEX('1819'!B13:D18,1,3),0)
User
14/06/2018 - 09:58
im not sure if i can send the file due to privacy
Excelchat Expert
14/06/2018 - 09:59
I understand... so I assume A1 is your drop down?
User
14/06/2018 - 09:59
yes
Excelchat Expert
14/06/2018 - 09:59
Ok perfect... and when you select 18/19 from the drop down, the INDEX function works fine?
User
14/06/2018 - 10:00
yes. however when i select 17/18 from the dropdown the value does not change automatically and i have to click in the formula tab and press enter for it to change
Excelchat Expert
14/06/2018 - 10:01
Does it display 0?
User
14/06/2018 - 10:01
yes
Excelchat Expert
14/06/2018 - 10:01
after you do that?
User
14/06/2018 - 10:01
yes
Excelchat Expert
14/06/2018 - 10:01
And that is what it's supposed to do, right? It's just it doesn't change automatically when you select the 17/18 option?
User
14/06/2018 - 10:02
yes thats it
User
14/06/2018 - 10:02
i need it to change automatically is this possible
Excelchat Expert
14/06/2018 - 10:03
That is so weird... i made a quick example in the google sheet and it seems to work. Let me do it in Excel and then try and search why it might not be working on your end
User
14/06/2018 - 10:04
ok thanks
Excelchat Expert
14/06/2018 - 10:06
Is this what you need it to do?
[Uploaded an Excel file]
Excelchat Expert
14/06/2018 - 10:07
I am checking now to see why it might not be working on your file
User
14/06/2018 - 10:09
hi
User
14/06/2018 - 10:09
sorry it cut out
User
14/06/2018 - 10:09
ill look now
Excelchat Expert
14/06/2018 - 10:09
Its all good! Did you receive the test file I sent?
Excelchat Expert
14/06/2018 - 10:09
Ok awesome
User
14/06/2018 - 10:10
yes
User
14/06/2018 - 10:10
it has the same problem
Excelchat Expert
14/06/2018 - 10:11
That is interesting indeed...
Excelchat Expert
14/06/2018 - 10:11
It's working on my machine. It must be a setting... let me check some more
User
14/06/2018 - 10:11
ok thanks
Excelchat Expert
14/06/2018 - 10:12
In the formulas menu, close to the top right, is the "calculation options" set to automatic?
User
14/06/2018 - 10:12
Ah!
User
14/06/2018 - 10:12
it was manual
Excelchat Expert
14/06/2018 - 10:13
Oh!
Excelchat Expert
14/06/2018 - 10:13
does it work if you change it?
User
14/06/2018 - 10:13
yes mate
Excelchat Expert
14/06/2018 - 10:13
Yesss amazing
User
14/06/2018 - 10:13
perfect wouldve here all day mate
Excelchat Expert
14/06/2018 - 10:13
Sorry this took so long!
Excelchat Expert
14/06/2018 - 10:13
Hey all good my friend
Excelchat Expert
14/06/2018 - 10:13
I hope you have an amazing day! All the very best ~
User
14/06/2018 - 10:13
yeah mate u too
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.