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.
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: