How do I create a cross reference database?

Hi there,

I am trying to create a cross-reference database in excel. I am not sure if I am using the correct terminology, so here is what I need to do:

I have three columns that contain text cells, each with different numbers of rows. Now imagine that cell A1 is related to cell B3 and also to cell C5. There are numerous different combinations similar to this. Is there a way to show this relationship between cells in excel. If so, how?

Thanks very much,
Edita

Hi,

I think you can do this by selecting your cell and then choose "Trace Dependents" or Trace Precedents... look at the attached image.. if this is not what you are looking for you let me know...

Regards