Forum Discussion
Lookup function HELP
I am trying to merge a couple of data sources that have differing text descriptions for the same item. One set has items identified by a UPC number only UPC 0085365000415 0085365000417 008536...
If the set with UPC and description is in Column B, starting with B2, you may use this formula in C2 to extract the UPC:
=SUBSTITUTE(RIGHT(B2,
LEN(B2)-FIND(“(“,B2)),
“)”,””)
=SUBSTITUTE(RIGHT(B2,
LEN(B2)-FIND(“(“,B2)),
“)”,””)