Check if a row contains a specific value without mentioning the column name

[Fira2 (Fi)]

Hello,
I have a datatable, I loop through each row, and I want to search for a specific string and get the column name/index. I tried "CurrentRow.ItemArray.Contains(string) in if condition but I got nothing

[ppr (Peter Preuss)]

one option would be to do it within a second for each looping over ItemArray
or LINQ

Enumerable.Range(0,CurrentRow.ItemArray.Length).Where(Function (x) CurrentRow(x).toString.Equals(string)).toArray

[Fira2 (Fi)]

how Can I replace X ? how can I use the LINQ please ?

[ppr (Peter Preuss)]

@Fira2
find starter help here:

inputdata:

search term FindMe

Result:

Find starter help here:
GetAllRowColIdx_By1Value.xaml (10.7 KB)

[Fira2 (Fi)]

thank you !!