geoffsmile
New Member
- Joined
- Apr 24, 2014
- Messages
- 7
Hello Everyone,
I want to learn if there is a formula that can search and provides a result, according to the set result that involves nesting. As seen on the table, I have a list of Merchant Tracking Numbers. All distinct on each way. UPS always starts its tracking number as "1Z" and USPS as "940". Please help me correct the formula which will help identify the tracking numbers on column "A". Let me know what am I doing wrong.
<tbody>
</tbody>
Appreciate the Help! Cheers!
I want to learn if there is a formula that can search and provides a result, according to the set result that involves nesting. As seen on the table, I have a list of Merchant Tracking Numbers. All distinct on each way. UPS always starts its tracking number as "1Z" and USPS as "940". Please help me correct the formula which will help identify the tracking numbers on column "A". Let me know what am I doing wrong.
Merchant Tracking Numbers | True Courier | Formula For Indentifiying | Formula Result |
1ZWF00980394816384 | UPS | =IF(SEARCH("1Z",A2),"UPS",IF(FIND("940",A2),"USPS","FedEx Ground")) | UPS |
9400115901195256406673 | USPS | =IF(SEARCH("1Z",A3),"UPS",IF(FIND("940",A3),"USPS","FedEx Ground")) | #VALUE! |
604209703070 | FedEx | =IF(SEARCH("1Z",A4),"UPS",IF(FIND("940",A4),"USPS","FedEx Ground")) | #VALUE! |
<tbody>
</tbody>
Appreciate the Help! Cheers!