VLOOKUP help

[Kazman]

I have a sheet (*edit* Excel 2010) that will track a set of instructors, the classes they teach, the hours taught and a few other fields.

I have a dedicated sheet for helper-cells, so I don't mind if it's ugly, I just want it to work. **I know it is likely more effecient with VBA, but this sheet will outlast my time here and needs to be fixable/updateable by someone with no VBA experience**

I'm having trouble with finding a way to show the instructors when a coursename is selected (my metrics are all based on a drop-down list cell).

required end result: When a user selects a coursename from the dropdown list in cell A6, the sheet should list all of the instructors who have taught that course.

This should work, but it's not working:

=VLOOKUP(A6,TableMain,2,FALSE)

A6 is the selected course#
TableMain has the following headers:
Date InstructorName Type of Hours Coursename Hours

the vlookup formula should look at what's in cell A6 (coursename) and try to match it with the data in TableMain and if it finds a match, return the value of column2 (instructor name) in that row right?

I keep getting N/A. Not sure what I'm doing wrong.

 

[VoG]

This may help http://www.contextures.com/xlFunctions02.html#trouble

 

[Kazman]

I was looking through other posts and got an idea to try, and it worked... sort of:

I used this instead
=INDEX(Main!C:C,MATCH($A$6,Main!E:E,0))

It returns the instructor name like I want it to, but only the first one.

lets say Smith taught that class 3 times and Johnson twice. I want it to show Smith in this cell and Johnson in the cell below it. Copying the formula down doesn't work. It just shows Smith over and over.