# Reference table for regexmatch formula

**URL:** <https://connect.superhuman.com/t/reference-table-for-regexmatch-formula/39575>\
**Category:** Ask the Community\
**Created:** [May 1, 2023, 4:54pm UTC](https://connect.superhuman.com/t/reference-table-for-regexmatch-formula/39575 "2023-05-01T16:54:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![PolarBear](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/polarbear/32/28930_2.png) [@PolarBear](https://connect.superhuman.com/u/PolarBear)\
**Post date:** [May 1, 2023, 4:54pm UTC](https://connect.superhuman.com/t/reference-table-for-regexmatch-formula/39575/1 "2023-05-01T16:54:49Z")

</div>

Hi Codans,  
I’m using a regexmatch formula to search a string for a list keywords, then tag them if a match is found. I’m planning on having many keywords with different tags if a match is found, so I want to list the keywords in another table for easier management, then reference the keywords in the regexmatch formula.  
Anyone know if this is possible?

 ![image](https://global.discourse-cdn.com/coda1/original/3X/9/6/96d446519cd63aff7234e8c6f1f9b15944bd3fc6.png)

---

<div class="post-metadata">

**Author:** ![Scott\_Collier-Weir](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/scott_collier-weir/32/29677_2.png) [@Scott\_Collier-Weir](https://connect.superhuman.com/u/Scott_Collier-Weir)\
**Post date:** [May 1, 2023, 6:03pm UTC](https://connect.superhuman.com/t/reference-table-for-regexmatch-formula/39575/2 "2023-05-01T18:03:01Z")

</div>

Hey Polar Bear!

Of course its possible! You are working with Coda

My solution below goes a little further than what you asked, as it shows how to hold multiple “groups” in a single table, but it should give you the direction you need to suceed!

Essentially, store your words in another table, refrence that table, then use `join()` to string them together with the regex OR operator.

 ![image](https://global.discourse-cdn.com/coda1/original/3X/6/2/6204aceb382052503e898491d333f660dbb17f40.jpeg)

---

<div class="post-metadata">

**Author:** ![PolarBear](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/polarbear/32/28930_2.png) [@PolarBear](https://connect.superhuman.com/u/PolarBear)\
**Post date:** [May 1, 2023, 6:39pm UTC](https://connect.superhuman.com/t/reference-table-for-regexmatch-formula/39575/3 "2023-05-01T18:39:12Z")

</div>

Thanks Scott. This is what I was looking for as I have several groups of keywords.

So, to incorporate more than 2 groups of keywords, I would have to use the SwitchIf formula then repeat the formula you shared for each keyword group, right?

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [July 30, 2023, 6:39pm UTC](https://connect.superhuman.com/t/reference-table-for-regexmatch-formula/39575/4 "2023-07-30T18:39:46Z")

</div>

Closed on July 30, 2023, 6:39pm UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.