Get row and column index of cell with specific value

I have a datatable and I need to find the position of one variable that appears in this data set. To be specific I need the column in which this variable exist. Values are unique, so there are no duplicates. Any suggestions?

Hi @trolleylolley,

Refer the below thread

Refer the below post for reference

1 Like

Thank you! I’ve did that using For Each loop with Lookup Data Table activity inside it.

In my case: List variable contains SAP symbol, and I look for correlated system name in data table.

You only need to change the names and indexes of columns where to look for data.

Feel free to use this workflow in your projects :slight_smile:

correlated_values.xaml (8.8 KB)

1 Like

Hi @trolleylolley,

Can you close the topic if you have received your solution

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