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

yedukondaluaregala (Yedukondalu_aregala) December 26, 2024, 10:01am 4

Please find the below xmal file
Testing_Forum (2).zip (742.8 KB)

try this xmal file and let me know if you are facing any issues

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