Hello,

I have a spreadsheet that lists document numbers that are stored in a document management system.  I have to cross reference the documents in that management system, which means I have to go into each individual document in the management system and add in all the documents where that individual document is referenced.  The attached spreadsheet lists all the documents in our system (column B) and each document where they are referenced (columns C-AP).  Is there a way to have Excel search columns C-AP, find a specific value, and provide me with a list from column B where that value is found in columns C-AP?

​Hello,I have a spreadsheet that lists document numbers that are stored in a document management system.  I have to cross reference the documents in that management system, which means I have to go into each individual document in the management system and add in all the documents where that individual document is referenced.  The attached spreadsheet lists all the documents in our system (column B) and each document where they are referenced (columns C-AP).  Is there a way to have Excel search columns C-AP, find a specific value, and provide me with a list from column B where that value is found in columns C-AP?   Read More

​