Hello,
I am trying to first find the correct formula to find data based on two different criteria on one worksheet and export the matching result into another worksheet for different days throughout the week. Example if my criteria is ID XX1234 and area YY, the total orders is 123. Input that 123 data into Mondays worksheet under the YY column. If criteria is ID XX1234 and area ZZ, the total orders is 456. Input that data into Mondays worksheet under the ZZ column. I have one column that will be the sum of two areas which is actually one department. Areas ZD and DK are to be summed into the UV column, DS and DF are independent of one another.
These daily complete order totals by ID/AREA will all roll into weekly total and summary worksheets. I have tried almost every combination of the VLookup and If functions together, Index and Match, Pivot Tables, you name it. The most recent formula that I have tried is:
=VLOOKUP(A4,Data!A3:D45, IF(Data!D3="ZD","",Data!C3),TRUE)
Eventually once I am able to make all of the data be populated into the worksheets I will work on a macro to automate this process. I pull the information in the data tab from a database that does not support excel. I manually input the area code to distinguish the different areas an associate my process orders. I have attached the file itself for any of you to play around with and see where I have gone wrong. If something needs to be rearranged due to formatting being the issue of the data not compiling correctly, feel free to arrange in the most practical way.
Thank you in advance for any assistance you may provide.
Bookmarks