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

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