Thread: How do I test a cell for a specific word if the cell has a drop down list.
View Single Post
 
Old 08-23-2017, 01:15 AM
RoehamptonTech RoehamptonTech is offline Windows 10 Office 2013
Novice
  
Join Date: Aug 2017
Posts: 1
RoehamptonTech is on a distinguished road
Default How do I test a cell for a specific word if the cell has a drop down list.
I am creating a finance spreadsheet and I want to test a cell which has a drop down menu for a specific 5 digit account number. My menu options are 30201 (Bill), 30201 (Fred) and 30205. When I test the cell, currently I use the IF function, I want it to return a value if it's 30205 or if it contains 30201. There will eventually be 10 drop down 8 of which will contain 30201 (a_name).

Any assistance would be greatly appreciated.

Thanks,

Jonathan
Reply With Quote