Question description:
This user has given permission to use the problem statement for this
blog.
good day I need some help with a formula. Need to check a statement with an if statement if true return "" if false choose from a drop down menu
Solved by A. F. in 26 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
13/06/2018 - 01:47
hi buddy
Excelchat Expert
13/06/2018 - 01:47
Hi, how can I help you in Excel
User
13/06/2018 - 01:47
I need some help with a formula. Need to check a statement with an if statement if true return "" if false choose from a drop down menu
Excelchat Expert
13/06/2018 - 01:48
Sure, do you have a excel file which you can share
User
13/06/2018 - 01:49
not on this computer
Excelchat Expert
13/06/2018 - 01:49
Ok, can you share the existing formula
User
13/06/2018 - 01:49
just wondering if you had any ideas
Excelchat Expert
13/06/2018 - 01:49
Or do you need the formula for doing this
User
13/06/2018 - 01:50
need the formula
Excelchat Expert
13/06/2018 - 01:51
Sure, so you need an if statement which will return blank if the condition is true and will return a value from a drop down if false, correct ?
User
13/06/2018 - 01:51
=IF(INDIRECT("'"&C$6&"'!"&INDEX('Data Validitation'!$M$2:$M$28,MATCH($C$2,'Data Validitation'!$N$2:$N$28,0))&(ROW(C11)+IF(OR($C$4="Fall",$C$4="All"),0,IF($C$4="Winter",11,IF($C$4="Spring",16)))))="","",--this is where I need to choose from a drop down menu--
Excelchat Expert
13/06/2018 - 01:51
o
Excelchat Expert
13/06/2018 - 01:51
ok
Excelchat Expert
13/06/2018 - 01:56
Please give me a few minutes, I am working on it and will answer this query
User
13/06/2018 - 01:56
no worries pal
Excelchat Expert
13/06/2018 - 02:13
=IF(INDIRECT("'"&C$6&"'!"&INDEX('Data Validitation'!$M$2:$M$28,MATCH($C$2,'Data Validitation'!$N$2:$N$28,0))&(ROW(C11)+IF(OR($C$4="Fall",$C$4="All"),0,IF($C$4="Winter",11,IF($C$4="Spring",16)))))="","",C1)
Excelchat Expert
13/06/2018 - 02:13
C1 is where you would have the drop down
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.