Anyone know of a way to match a number in one column to a number inside random text in another column, then populate the match in the formula column. See Below ex.
Column I Column J Column K
Formula column Search Column Column Trying to Match To Text In Column J
Result
Ticket # Description Ticket#
120815
<colgroup><col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3620;">
<col width="477" style="width: 358pt; mso-width-source: userset; mso-width-alt: 17444;">
<tbody>
</tbody>
Column I Column J Column K
Formula column Search Column Column Trying to Match To Text In Column J
Result
Ticket # Description Ticket#
120815
1208015 | POLE: NJUNS 1208015 TRANSFER @ NJUNS REQUEST @ POLE BETWEEN 13082 & 13092 BETHANY RD TERM #13050 |