Excel 2007 : Formula problem

[next27]

Hello,

I have 2 sheets ( x and y)
in sheet "x" i have store names (A1:23) (23 stores)in the first column(it's a hypermarket chain), in the second column i have the email adresses of the managers from the repective locations (B1:23)(23 managers). Sometimes i have to send mails to only a part of these 23 managers. But i always receive from companies the list of the stores. so i would like that when i write the name of one store in sheet "y" let's say in A1 cell, in the cell B1 it returns the email adress of the manager from that respective store. I also attached a table for example might be easier then what i explained.

Thanks in advance,

[som3body]

You might be breaking rule one of the forum. Check the attachment That should help, You can also make the manger choice a drop down list if needed.

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.