conditional formula

[Guest]

This may be simple, but the answer eludes me.

I want to enter a formula which is conditional on other cell values in a
range. column A has a list of names, column B has their email. cell c3 has
validation based on the list of names in column A. the formula in cell d3
needs to populate the email for the person selected in C3.

So far i can get a formula to only work for single cells but not a range.
=if(c3=a3,b3,0). I need more than just a3 and b3, i need a3:a12 and b3:b12

anyhelp is appreciated

 

[Biff]

Hi!

Try this in cell D3:

=IF(C3="","",VLOOKUP(C3,A3:B12,2,0))

Biff

 

[Guest]

works like a charm, thanks

i knew it was simple, I am new to the vlook function

 

[Biff]

You're welcome!

Biff

works like a charm, thanks

i knew it was simple, I am new to the vlook function