skylinekiller
New Member
- Joined
- May 3, 2004
- Messages
- 48
Good afternoon! Part of my problem with Excel is I don't know what the function is called that I want to do. I am currently working on a small sheet where I need the following:
If Column B has the word john, then I need Column D to show the email jon.doe, if Column B has the word Jane, then Column D needs to show a different email. There are only a handful of emails so I would like to place this in the initial function (not reference another cell"
Is this in IF function or a V-Look?
If Column B has the word john, then I need Column D to show the email jon.doe, if Column B has the word Jane, then Column D needs to show a different email. There are only a handful of emails so I would like to place this in the initial function (not reference another cell"
Is this in IF function or a V-Look?