I need a formula that search for numbers and displays one or more text correspondents

Hello everyone!

I have this formula:

=IF(REGEXMATCH(C2, "05"), "General",IF(REGEXMATCH(C2, "15"), "API",IF(REGEXMATCH(C2, "10"), "FEM-Design",IF(REGEXMATCH(C2, "20"), "WIN-Statik",IF(REGEXMATCH(C2, "25"), "Dimension",IF(REGEXMATCH(C2, "27")))))))

I use it in Google Sheets to transform an Index Number (coming from a CRM) into the Software associated with this Index in the CRM.

I then go with the text information in ActiveCampaign.

The problem is the following: the formula works for cases where a contact is interested in only one software (for example 15 -> API). But if the contact is interested in more than one software (for example 15, 10) the form will not display the software names with a comma (for example API, FEM-Design).

Can you help me modify the formula so it works for more index numbers it finds?

Thank you.

Instead of nesting the IFs, you would need to keep them separate (but in the same cell) and concatenate the results.

Formula:

Please Login or Register  to view this content.

Hello BogdanAGH and Welcome to Excel Forum.
If this were Excel you could use:

Formula:

Please Login or Register  to view this content.

I think that might translate to:

Formula:

Please Login or Register  to view this content.

EDIT: the order of the &IF sections in the formula and the order of arrangement of the values in cell C2 is important.
Let us know if you have any questions.