Hi all,

I have a worksheet I want to put the schedule of classes for a particular teacher. The information that I need is located on another worksheet in columns.

Here's an example:

Column 1 Column 2
Instructor 1 Finance
Instructor 2 Accounting
Instructor 1 Management

The function would need to search the table for the specified instructor and pull the information in the cell to the right of it. It would look like this.

|Instructor 1|Finance |
|Instructor 1|Management|