How do I create a checklist to auto-fill another doc using excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a course catalog for online learning. I have created a
matrix where I have courses listed down the left hand side and job titles
accross the top. I want to be able to click in the boxes under the job titles
to assign courses and have the information for each course auto-populate /
auto-fill into another document or spreadsheet.

Any suggestions?

Thanks in advance!
 
One way is INDEX/MATCH

Illustrated in this sample:
http://cjoint.com/?jAbJsgtWDZ
Index match example.xls

Source table assumed in X, courses listed in A2 down, titles in B1 across

Then in Y,

In C2, copied down:
=IF(COUNTA(A2:B2)<2,"",INDEX(X!$A$1:$D$6,MATCH(B2,X!$A:$A,0),MATCH(A2,X!$1:$1,0)))

where in A2 down are Titles, in B2 down are Courses
 
Back
Top