-2

I have a few columns in an excel spreadsheet. Basically, I am trying to match partial string from one cell to another. I need help creating the results in column B and column C below in excel. Preferably formula. If not, vba is fine as well. The goal is to compare List_A to column D, E, F. Thanks!

enter image description here

I tried the following: 1. Split out List_A into different columns by using comma delimited. But did not know how to go forward because values in Column D,E,F might not always in order. So I can't compare cell to cell.

Community
  • 1
  • 1
Futochan
  • 321
  • 2
  • 9
  • 19

1 Answers1

2

You are just in time to use the new TEXTJOIN function available in / and .

    textjoin_xlol

The formula for column C is based on the SUBSTITUTE function.

  • I do not have excel 2016. I am using 2010. – Futochan Mar 22 '16 at 15:58
  • Well, there are many examples of VBA UDF string concatenation functions on this site. I know because I've written at least a dozen myself. See [udfUniqueList](http://stackoverflow.com/questions/36092790/formula-for-unmatched-row-cell-and-display-value-in-one-column/36094199#36094199). –  Mar 22 '16 at 16:04
  • I have Excel 2016 locally installed but I do not have a subscription. So, I cannot use it either. Having Office 2016 does not suffice (unfortunately). – Ralph Mar 22 '16 at 17:21
  • Yes, with xl2016 desktop you need an Office 365 subscription but you can still use it online. –  Mar 22 '16 at 17:23
  • I didn't know that and just wanted to try it now. Unfortunately, Excel Online is too smart for me. It seems to change the language automatically to where I am currently connecting from. My browser is English, my system is English, and my OneDrive account is English. Still, Excel online knows better and changes to the local language (menu bar & formulas) and I am lost. Tried to fix it but couldn't find a solution. So, I am giving up for now. – Ralph Mar 22 '16 at 17:41
  • @ralph - Change the URL to force the 'market' or regional area. e.g. `https://office.live.com/start/Excel.aspx?omkt=en-US` –  Mar 22 '16 at 17:45
  • @Jeeped: Thank you. I clicked / opened your link. Still, all is opened with local language (which they can only get from my IP as everything else is English). I also looked for the option to change languages as mentioned here: http://www.digitalcitizen.life/how-change-language-used-outlookcom-office-online-more Still, OneDrive knows better. – Ralph Mar 22 '16 at 17:50