Show extra results based on column data

Cozapunk

Hi, first off, awesome plugin, so glad I found it. Ive been reading through the posts here, and so far haven't found what Im looking for. Hopefully I can explain my issue clearly enough that someone can point me in the right direction.

I have a table with multiple columns, one of them being NAME and another being CATEGORY. Each category has multiple rows. What I am trying to achieve is the following:

If a user searches for a NAME, the result should show the row for the name that was searched for, PLUS rows for all other names that are in the same CATEGORY as the original search.

So if I had for example

Name | Category

Bob | Builder
Mario | Plumber
Luigi | Plumber

A search for either Mario or Luigi would return both of those rows, as they are both in the Plumber category.

Any help would be greatly appreciated__