• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Partial string match (Solved)

Bhbronko

New Member
Hi,
I have two sheets containing currency data. I'm wanting to match two columns with similar text.

Sheet1, Column "ADDON_KEY"
E.g. row ProductGroup.FX.10Y.AUD.CAD

Sheet 2, Column "CounterpartyId"
e.g. row Cpty_CAD_AUD_FXForward_10Y_Long

I'm wanting to output the contents of CounterpartyId, alongside ADDON_KEY.

I'm a bit stuck, I feel like I want to use XLOOKUP with a wildcard function included but I feel the period/underscore difference would create a problem.

Any help would be really appreciated.
 
Last edited:
Back
Top