Hi,
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.