**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.*