TheBlueMan15
New Member
- Joined
- Aug 30, 2018
- Messages
- 3
Hi, sorry that my title probably doesn't fit my question correctly, but I didn't know how to describe it.I have a table of document numbers and the other document numbers that are referenced inside:eg document 1 references documents 2, 3 and 4, document 2 references 1 and 3. What I'm looking for is a formula where I put in the document number and it tells me all the documents that it has been referenced in:eg I put in number 3 and it tells me that it was referenced by document 1 and 2.I tried index matching but was getting nowhere.Thanks in advance for the help!