How to find the particular cell value position in datatable

[sandhyak9 (sandhya)]

Hi Guys.I have two sheets in excel file.In first sheet only one column is there.In second sheet contains a large amount of data.First I have to pick the each column cell value in first sheet.And have to go to the second sheet to search for the same value and get the position of the cell.Can anyone help me please.Thanks in advance

[PAD]

Hi @sandhyak9
If you read your first sheet with Read range, so the output will be a datatable, and then for each row you use Get row item, you can use later the below threads:

Find cell with String Value and get no. of row, name of column

Thank Arivu, I am trying to get position’s information of cell have title “S.TL” by message box like below. Now I can only find value text cell by each row and get no. of column (But not correct, first cell show to me message box is “column5”). [Capture] If we have correct no. of column, how to change to name such as “I10” or get no. of row or name of column. This my file is testing. TestFindPosition.xaml (14.2 KB) Please help to check. Thanks

Find a cell position in Data Table

Hi Tomas, Yes you can do this. You will need the row number within the DataTable and the column Index. To get the row number, you can simply have a counter inside a loop (but that can be slow). If you are using vb.net to pull out the row that contains a word then you can use the .IndexOf() function, I believe. For Example, rowIndex =(datatableVariable.Rows.IndexOf(datatableVariable.AsEnumerable().Where(Function(row) row(0).ToString.Contains(“word”)).ToArray()(0))+1).ToString Then you need …

for v2018.2:

Activities - Lookup Data Table

[Karthick_Settu]

Check this file.
Main.xaml (10.8 KB)

[sandhyak9 (sandhya)]

Thank you @Karthick_Settu.your code is working.But I have a problem now.Actually In sheet1,there is only column consists different cell values.Each cell value has a set of Child cell values in sheet2.Now,I have to pick up first cell value from sheet1.And have to come to Sheet2 and pickup the first child cell value.And then back to Sheet1,have to pickup the Second cell value,and go to sheet2 to pickup the first child value of the Second Cell Value.Like this,Once all the Cell values have completed,again it have to go to pick up first cell value of sheet1,then go to sheet2 and pick up the Second child cell value.Like this,Loop has to work.Can you Please help me on this.