Excel help

I need help creating formulas in Excel. I use it for time entries for my law practice. I would like to have a drop down list that auto populates from a list of clients and matters, and once an item is selected from the list, it would simultaneously populate the two adjacent cells with the client number and matter number, respectively. The client names, numbers, and matter numbers would be indexed on another sheet in the same workbook.