Need formula to extract info

[mhartman09]

I have a spreadsheet set up to use as an employee info and training matrix. I'm trying to set up a new tab to give a summary by employee.

Here's a screenshot of the matrix:

Here's a screen shot of the employee summary tab I'm trying to make:

The employee name is entered through data validation using the list of employees from the matrix. I've used vlookup to enter the details for each employee at the top. I'm running into an issue trying to extract the training course info at the bottom. Not every employee will have something entered under each type of training. Some are only required to have certain training classes.

Any idea how I can get the employee's training class details to pull over from the matrix when I select that employee? I don't think I can use vlookup because I would need the course name to pull over as well. Also, as I said before, some columns would be skipped in the matrix and I don't want to leave blank rows under the training info in the summary. I'm really at a loss and have been working on this for quite a while.

FYI - I'm not familiar with VBA at all, so if this is possible to do using formulas I'd prefer that. If not, I'd really have to work at understanding how to make this happen.

Michelle

 

[venkat1926]

perhaps I have missed. where is the training data of each employee, if at all. give cell addresses in the main data base

 

[mhartman09]

I actually haven't entered the training info into the spreadsheet yet. It will be entered beginning in cell AC3. Each column labeled "completed" will have a date and a teacher's name will be listed in the "instructor" column. These two things will be entered for every training course. Some also have a column for "due" and "details". These two things are not required for every course. Does this help?

 

[Excelestial]

I've found that the OFFSET function works best for this situation. With the OFFSET, once the vertical lookup is locked in, the targeted training info can be located and pulled in. It would help to see your matrix so that I could write a sample OFFSET formula for you.

 

[scottylad2]

have you looked at Index/Match?