Finding Cell that Contains a Value and Displaying its Contents

[GreyEyedWolf]

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 <tbody> </tbody>	FilePath2 <tbody> </tbody>	FilePath3 <tbody> </tbody>	Desired Results Path <tbody> </tbody>
C:\Docs.RAR\photo1.jpg <tbody> </tbody>	C:\Docs.Rar\Photo2.jpg <tbody> </tbody>	C:\Zip.ZIP\File.doc <tbody> </tbody>
C:\Zip.ZIP\File7.doc <tbody> </tbody>	C:\Docs.RAR\File2.doc <tbody> </tbody>	C:\Docs.RAR\photo5.jpg <tbody> </tbody>
C:\Docs.RAR\FinalExam5.doc <tbody> </tbody>	C:\Zip.ZIP\new.jpg <tbody> </tbody>	C:\Docs.RAR\facebook.txt <tbody> </tbody>

<tbody>
</tbody>

Basically I would want to search rows A2-C2 within that example and just display the value containing "Zip.ZIP" into cell D2. So in this case I would want to see C:\Zip.ZIP\File.doc in cell D2. Then I would want to run that same formula on the 3rd row and see the value C:\Zip.ZIP\File7.doc from cell A3 in cell D3, then the value from B4 in D4 and so on... Is there a way I can run searches along a horizontal plane and display only the contents of the cell containing the value I'm interested in within column D? Or is there an easier solution that I haven't thought of?

Thanks

 

[GreyEyedWolf]

I do agree with you, thank you very much!