How do I test a cell for a specific word if the cell has a drop down list.

RoehamptonTech · #1 08-23-2017, 01:15 AM

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

NBVC · #2 08-23-2017, 05:05 AM

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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 add selection of multi line content control list to specific table cell	Dudlee	Word VBA	1	09-20-2016 04:58 PM
Get next non empty cell from a specific list with VBA	chriss17	Excel Programming	2	06-15-2016 08:40 AM
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