Vlook up returning multiple values

Hi,

I have created a spreadsheet to record training in our company. I have created a look up function to search on employee name to return the department, traininf course and cost. Obviously this will only returnt one entry and an employee may attend more than one course in the year. I looked on the web and follow the instructions to create this formula; =INDEX($A$14:$J$109,SMALL(IF($A$14:$A$109=$A$4,ROW($A$14:$A$109)),ROW(1:1)),2) but it returns an #value error. I investigated further and it seems to be to do with the formatting. Some of the results will be in text and some in numbers so I tried to change the format of the cells but I still get this error.

can you please help?

Thanks
Julie