How to extract data from sheet2 excel to notepad by using reference number in sheet 1 excel

Help
,
1

Hi guys,
I need to extract data from sheet2 using sheet1 reference number and put the data in notepad… for example in sheet 2 i ll have

sheet2.png1366×768 49.5 KB

in sheet 1,

sheet1.png1366×768 53.1 KB

i need to extract data of 1, 3 and 4 from sheet 2 and place those data in notepad…
if anyone know please help me guys

2

Hi Sunitha, you can read both ranges into data tables and then use this solution https://www.uipath.com/kb-articles/simulate-excel-vlookup-in-a-datatable