what is this function called?

[skylinekiller]

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?

 

[Logit]

Assuming your list of email addresses are found somewhere in the workbook, in a vertical orientation (as all in Col A), then VLOOKUP is your choice.

 

[skylinekiller]

No, I had not plan on placing all the emails in there. Do I need to do that? I thought I can just write them in one funciton

 

[Logit]

You can write the emails in the Macro Code if you wish. And you can use the IF function.

 

[Peter_SSs]

I thought I can just write them in one funciton

You can. This assumes that every name in column B will appear in the formula. If it is possible that other names, not in your formula could be in column B then a slightly different approach would be needed.
With this formula the list of names in the first curly brackets in the formula must be in alphabetical order.

21 04 12.xlsm
	A	B	C	D
1
2		John		johnboy@gmail.com
3		Jane		jane@elsewhere
4		Ken		kenneth@there
5		Bob		bob@somewhere
Lookup emails

Cell Formulas
Range	Formula
D2:D5	D2	=LOOKUP(B2,{"Bob","Jane","John","Ken"},{"bob@somewhere","jane@elsewhere","johnboy@gmail.com","kenneth@there"})

 

[skylinekiller]

Thank you. This pretty much solved the question, although I don't think it's as practical as I first thought. For educational purposes, what is the correct title of this function/formula? Is it just look up or Lookup array?

 

[Peter_SSs]

This is a LOOKUP (Vector form) function.

I don't think it's as practical as I first thought

In what way? Is the list much bigger than you first thought?