How to vlookup between two excel sheets with unique column reportid, using studiox UiPath. Can someone give an idea about it I tried on multiple ways

@govindreddy_nagireddy Try this <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/4/2/f/42ff78de5e5158ca4ceea008983ceb44adbfad4b.png" data-download-href="/uploads/short-url/9yGRigNNbDDeK0qHOD0K0QX2b8f.png?dl=1" title="This image depicts a workflow for automating Excel tasks, including assigning a file name, using an existing Excel file, writing a VLOOKUP formula to a specific cell, and applying autofill in an Excel sheet. (Captioned by AI)">[This image depicts a workflow for automating Excel tasks, including assigning a file name, using an existing Excel file, writing a VLOOKUP formula to a specific cell, and applying autofill in an Excel sheet. (Captioned by AI)] Input: Excel1: [The image shows an…

VLOOKUP USING studioX

Help StudioX

lrtetala (Lakshman Reddy) September 20, 2024, 11:56am 2

Hi @govindreddy_nagireddy

Please check below thread, If possible share your sample input excel and output

Regards,

Topic		Replies	Views
Vlookup in One file but in two different sheets Academy Feedback excel , uiautomation , activities , studiox	1	1166	December 11, 2019
Vlookup betwen different sheets of different xlsx files Help excel , activities , question	7	1463	November 18, 2019
I need to use a unique identifier from sheet 1, look it up in sheet two and then copy over data from specific columns of sheet two to sheet one StudioX studiox , question	3	453	January 14, 2023
Vlookup between two different excel file sheets Help excel , activities , question	9	6663	August 27, 2020
How to use vlookup for two different excel file? Studio excel , studio , question , extension	14	1449	May 3, 2024

VLOOKUP USING studioX

Related topics