Extracting string data to match search and find cell location

[aussiebail]

Thank you all for the great help this site has already been to me. I apologize upfront if I provide too much detail, but I do want you to be clear with my request.

Column E Column F

Summary: What I need to accomplish is to extract the string data from column F to see if it has a match. In this example there are 2 order numbers. A pickup "P", and a delivery "D". The "D"'s have a value that I need to reference in column O. The "P"'s have no value.

This is the formula that I currently have and I am close, but I need the formula to give the "P" cell the corresponding "D" row location, and then reference the location for column O to output the full O address. So the issue I see is that I am subtracting the wrong thing. I thought that I was subtracting the "p" cell, but it introduced an error, which now gives me a value of zero.

=IFERROR(ADDRESS(AGGREGATE(15,3,(SEARCH(MID(F341,1,13),F340:F344)*(ROW(F340:F345))-SEARCH("P",F340:F345)/(SEARCH("P",F340:F345))*(ROW(F340:F345))),1),15),"")

 

[aussiebail]

For some reason my picture didn't show. Here is that info


[TABLE="width: 150"]
<colgroup><col></colgroup><tbody>[TR]
[TD]032-157-50512D:0607[/TD]
[/TR]
[TR]
[TD]032-157-50456D:0607[/TD]
[/TR]
[TR]
[TD]032-157-50512P
[/TD]
[/TR]
[TR]
[TD]032-157-50456P[/TD]
[/TR]
</tbody>[/TABLE]

 

[aussiebail]

What I really need is to know how to subtract the "p" cell from the search once it is found.

 

[aussiebail]

bump