How can I tell an IF statement to return a value from a drop down list in another cell.

**Laurennotsur** · 12-12-2014, 01:22 PM

Hi,

Help please!! I am trying to get a value returned when a condition is met - that value being from a drop down in another cell.
My formula looks like this: =if(AB4="AP",""Please enter approval date,"") Cell AB4 has a drop down set up, I want this if statement to return "Please enter approval date" IF cell AB4 states AP, If not leave cell blank.
However it will not let me as cell AB4 is a drop down cell so the word AP is not actually input (to eliminate data input error)

Help/advise please :-(

Thanks
Lauren

**Glenn Kennedy** · 12-12-2014, 01:27 PM

Try this:
=if(AB4="AP","Please enter approval date","")

**etaf** · 12-12-2014, 01:29 PM

did you mistype the formula - it should be

=if(AB4="AP","Please enter approval date","")

should work with a dropdown

How can I tell an IF statement to return a value from a drop down list in another cell.

LinkBack

Thread Tools

Rate This Thread

Display

How can I tell an IF statement to return a value from a drop down list in another cell.

Re: How can I tell an IF statement to return a value from a drop down list in another cell

Re: How can I tell an IF statement to return a value from a drop down list in another cell

Thread Information

Users Browsing this Thread

Similar Threads

Return value based on selection chosen from drop-down list in cell next to it

Need to access certain elements in a drop down list and return values from another cell

IF Statement-Auto populate a cell w/ a drop down list of items from a seperate xls file

Drop down list with an if statement

[SOLVED] Drop down list with an if statement

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions