Finding a row with a given cell value inside a table component


This is probably something very simple, but I just couldn't find the way to do this.

Basically I know the information from one of the cells and I would like to find the row which contains the given cell value, then access another cell of the same row. I guess if I could get the index of that row somehow that would help me a lot.

If this info helps: the table is based on a Google Sheets query and the values I know are unique ones (product IDs) so always there will be just 1 search result.