GreyEyedWolf
New Member
- Joined
- Jul 26, 2014
- Messages
- 14
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.
<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
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.
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<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