IF/Then

[billtester]

Good afternoon.

I am trying to get a return value in a cell based on a range of cells. The formula I tried was:

=IF(E19=E1:E10,F1:F11) but it returned an error.

E19 contains a drop down of salesman initials. I want F19 to populate with the corresponding salesman names and G19 to populate with the email address.

I have the Initials in a range from E1:E10
The Salesmans Names are in F1:F10
The email addresses are in G1:G10

Thank you in advance for your help!!!

 

[VoG]

Names

=VLOOKUP(E19,E1:G10,2,FALSE)

E-mail

=VLOOKUP(E19,E1:G10,3,FALSE)

 

[billtester]

Thanks Peter!!! You are the man

 

[billtester]

Is there a way to have the cell remain blank if the value is false rather than showing the #N/A message?

 

[VoG]

Try

=IF(ISNA(VLOOKUP(E19,E1:G10,2,FALSE)),"",VLOOKUP(E19,E1:G10,2,FALSE))