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

[Vigneswaran]

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 solution]

Hi @Vigneswaran 

One way of doing this

[ShankerV · Accepted solution]

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