I have created a list in my cell "B1" that is composed of various professions. I want to create an If Statement that will automatically fill in another cell based on what the user selects as the profession, but I'm having a hell of a time - for some reason, Excel is giving me an error message and highlighting the IF immediately before "((B1="Police Officer"). Here is my If Statement.
I have already checked my list to make sure that "Police Officer" is in it exactly the same - it was. Any help would be awesome.
Update/Note: It works perfect if I delete everything after the Nurse statement. Also, nothing after the Nurse statement works - if I delete Police Officer, the last ones don't work.
Son of a bitch, I am pretty sure it's an issue with how many embedded IF statements there are. Is there any way that I can use all these IF statements or at least have all this stuff in one cell without the use of a VLOOKUP or something of the like?
Update - well, turns out I just did it with a VLookup. It was actually much easier than I had anticipated. Stupid 7 nested IF's.
Question
Dave Diller
I have created a list in my cell "B1" that is composed of various professions. I want to create an If Statement that will automatically fill in another cell based on what the user selects as the profession, but I'm having a hell of a time - for some reason, Excel is giving me an error message and highlighting the IF immediately before "((B1="Police Officer"). Here is my If Statement.
I have already checked my list to make sure that "Police Officer" is in it exactly the same - it was. Any help would be awesome.
Update/Note: It works perfect if I delete everything after the Nurse statement. Also, nothing after the Nurse statement works - if I delete Police Officer, the last ones don't work.
Son of a bitch, I am pretty sure it's an issue with how many embedded IF statements there are. Is there any way that I can use all these IF statements or at least have all this stuff in one cell without the use of a VLOOKUP or something of the like?
Update - well, turns out I just did it with a VLookup. It was actually much easier than I had anticipated. Stupid 7 nested IF's.
Edited by Dave DillerLink to comment
Share on other sites
1 answer to this question
Recommended Posts