auto population and drop down menus over two sheets

[briandawson26]

Not sure how to get around this one.

Am working on two sheets in same workbook

Sheet 1 is a list of clients and contact details. Column A is Clients. Column B is the client contact

Sheet 2 I'm doing as a daily report on which clients were contacted what was discussed etc.

Column A is the Client contacted which I've set up a drop down menu for. Column B will be who ever I've spoken to which for the most part will be the regular client contact.

What I want to do is have column B auto populate with the client contact based on the client selected from the drop down menu in column A.

Thanks for any help in advance.

[Tony Valko]

It sounds like you want to do this:

http://contextures.com/xlFunctions02.html