• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to multiply values in one sheet with values in another sheet

narsing rao

Member
Hi ,

i have pivot table with values , now i want to multiply those values with other values in different sheet in a such away that ,cell data look for the same user name first and then the values should get multiplied.

small example below:

sheet 1
abc_Report xyz_Report

John 5 0
Mark 0 2

sheet 2
Processing time John Mark

abc_Report 20min 20*5 0

xyz_Report 50min 0 50*2

please find the example in pic view

upload_2017-9-20_19-31-27.png

as shown in sheet 2 values should get populated.
in above processing time values are hard coded. they wont get changed.

in above example i have given example with two values but in real scenario it is dynamic like user may increase or decrease.

any help is appreciated
 
Last edited:
Back
Top