how to get second column value based on first column value

Have you test the XAML file. It will gives you the output @Yogita_Gaikwad

How to get value from excel1

Yogita_Gaikwad (Yogita Gaikwad) September 1, 2022, 9:17am 13

output of this for 102 is suraj and sam is right and can u tell me if i want to remove row suraj and sam from second excel where they are present

Topic		Replies	Views
Get Value of Second Column each row Help	1	2043	April 8, 2019
How to get the corresponding values from another column if the value gets matched in the first column Activities excel , activities , question	11	5275	February 14, 2022
Get cell value without using For each row activity Help datatable , excel	3	5381	October 29, 2018
Compare the value is there or not in excel and get the corresponding column value Studio studio , question , activities_panel	5	1106	February 12, 2022
Get specific Excel column values (two column values with same column name but with different column positions) based on one source column(Let's say source column is A)) Activities excel , activities , question	13	1166	December 12, 2020