Hello Everyone, I have the following scenario: Excel1 Requestor name : John Category : light, Internet Total : 20,36 , 15,54 Excel2 Employee Name : John Light : Internet : I need to search for the requestor’s name in Excel2 under the ‘Employee Name’ column and place the corresponding tota…

Search for value in another Excel and place the total value in 2 different column corresponding to that value

supriya117 (Supriya Allada) December 26, 2024, 10:11am 5

Check this:
Sequence.xaml (26.8 KB)

Topic		Replies	Views
Searching a value from one column in excel to another column in other excel Help excel , activities	6	6312	November 16, 2017
Finding a value from each row in a column in one excel with another column in another excel Help	2	4866	September 19, 2017
Compare 2 excel files row item and paste in 3rd excel file Community datatable , excel , orchestrator , robot , question	7	511	June 8, 2023
Excel matching and write to column Studio studio , question , designer_canvas	2	670	April 9, 2021
Adding two column values In DataTable Studio studio , question , output_panel	15	583	November 13, 2023