Hi this is my first time and I need easy to follow help.
I wish to make at least 3 columns of information . in col1 will be a list of subjects. In col 2 will be a larger list of subjects referring to each individual subject in col1 and in col 3 another list referring to each subject in col 2.
Eg.

Subject 1. Subject A. Subject 1Aa
Subject 1Ab
Subject 1Ac

Subject B. Subject 1Ba
Subject 1Bb
Subject 1Bc

Subject C. Subject 1Ca
Subject 1Cb

Subject 2. Subject D. Subject 2Da
Subject 2Db
Etc

I want to be able to bring up any subject in col 2 or col 3 in a search and have the necessary information beside it in the other columns. For example if I search for the details such as subject 1Bc in col 3 then the details in col 2 will show subject B and the details of col 1 will show subject 1.
There is a probability the col 1 may have 100+ subjects, col 2 will have 2/3+ subjects per subject in col 1 and col3 may have 4/5 subjects per subject in col 2.
(Hope I have explained this properly)
If it can't be done in word can it be done in excel?