Most valuable professional
  • Hot Topics

Excel Finding Cell that Contains a Value and Displaying its Contents

Hello, I was wondering if anyone could help me with my task? I basically have a large range of data both vertically and horizontally. The contents from cell A-O horizonally contain various different file paths, but I am only interested in finding the path with a certain ZIP file mentioned within it. I have posted a much smaller version as an example of my task below. FilePath1 C:\Docs.RAR\photo1.jpg C:\Zip.ZIP\File7.doc C:\Docs.RAR\FinalExam5.doc

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of September 14, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel