Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-23-2017, 01:15 AM
RoehamptonTech RoehamptonTech is offline How do I test a cell for a specific word if the cell has a drop down list. Windows 10 How do I test a cell for a specific word if the cell has a drop down list. Office 2013
Novice
How do I test a cell for a specific word if the cell has a drop down list.
 
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
  #2  
Old 08-23-2017, 05:05 AM
NBVC's Avatar
NBVC NBVC is offline How do I test a cell for a specific word if the cell has a drop down list. Windows 10 How do I test a cell for a specific word if the cell has a drop down list. Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

I am not 100% sure I understand.

Are you able to post a sample workbook showing what you are trying to do and expected results?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Drop Down list to change cell color bksmith Excel 2 08-21-2017 02:37 AM
How do I test a cell for a specific word if the cell has a drop down list. How do I add selection of multi line content control list to specific table cell Dudlee Word VBA 1 09-20-2016 04:58 PM
How do I test a cell for a specific word if the cell has a drop down list. Get next non empty cell from a specific list with VBA chriss17 Excel Programming 2 06-15-2016 08:40 AM
How do I test a cell for a specific word if the cell has a drop down list. Change cell color when selection is made from a drop down list fedcco Excel 12 08-28-2012 10:43 PM
Auto add a list cell if the last list cell is filled tasuooooo Excel 1 07-31-2012 08:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft