Volume Data from 1 sheet to another based on 2 criteria
excel.PNG
Hi Everyone,
Could someone please help with a formula that will pull volume data from one column on a different workbook? It needs to be based one product number AND date, so if both these values are in an array it will spit out the volume. I've attached a picture for reference.
Thank you in advance!
Jen
Bascially there are many optios but you can take help of SUMPRODUCT. Write the formula as- =SUMPRODUCT(A1=Sheet2!$A$2:$A$100)*(C3=Sheet2!$C$2:$C$100),Sheet2!$D$2:$D$100)
You can take help from below link.
"rb.gy/k4lf3l"
Hi Sybon, Thanks for helping! I'm not looking to total these volume numbers. I'm looking to pull the value from the volume column in sheet 2 over to sheet 1 if it is product 1 and 1st Jan 2020. I'm currently doing a vlookup but its pulling 100 as a volume for every product no 1 and not pulling 200 if its product no 1 but 2nd Jan 2020. Does that make sense?
Hello jennifer.muirhead and Welcome to Excel Forum.
Sybon's formula is basically correct, although it would be easier to know which cells to reference if we could see an .xlsx file (instructions in banner at top of page) rather than a screen shot that is not showing columns nor rows.
As you are new to this site I have provided a file.
Assuming "Product Number" is in cell A1 on both sheets put the following into cell D2 on sheet 1 and copy down: =SUMPRODUCT((A2=Sheet2!$A$2:$A$100)*(C2=Sheet2!$C$2:$C$100),Sheet2!$D$2:$D$100)
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks