Calculate amount based on "File1" and populate values in "File2"

Question

Hi Pros,

I need to calculate the amounts based on the value in Excel File 1 and after computing I want to populate the values based on the header (sector) in the Excel file 2 - which will be given to the consumer

Example.
1) Need to sum the Car and Bike in the category field (in file 1)
2) The total value should be populated in the Automobile column (in file 2)

Sheet 1

Sheet 2 (Output)

How can I achieve this ?

Thanks in advance

Felipe_Ribeir0 · Accepted Answer

Hi @Vigneswaran

One way of doing this

ShankerV · Accepted Answer

Hi @Vigneswaran

One way of doing this is,

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V