+ Reply to Thread
Results 1 to 2 of 2

VLookup/IF Find data by two criterias, input results into differant worksheet

  1. #1
    Registered User
    Join Date
    02-08-2016
    Location
    Memphis, Tn
    MS-Off Ver
    Microsoft Office 2010 and 2013
    Posts
    7

    VLookup/IF Find data by two criterias, input results into differant worksheet

    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.
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: VLookup/IF Find data by two criterias, input results into differant worksheet

    First shot in C4 sheet "Mon"

    Please Login or Register  to view this content.
    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

    This pick the sheet name automatically (under pattern: "Mon","Tues","Wed","Thurs","Fri").

    Copy to other sheets, or copy to new sheet then change the sheet name.
    Quang PT

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Input box to search and results in a new worksheet
    By Ashley1993 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-02-2014, 09:42 AM
  2. [SOLVED] How to automatically use input values and copy results to a different worksheet?
    By mijnrath in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-16-2014, 01:55 PM
  3. Trying to input data from one sheet based on two criterias on another
    By danikva in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-03-2013, 07:39 PM
  4. [SOLVED] 2 criterias to organize data by VLookup
    By douglascaixeta in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 03-31-2013, 12:05 AM
  5. Worksheet function Vlookup and VLOOKUP return different results
    By zandero in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2010, 08:24 AM
  6. Need Help With A Spreadsheet - Making differant boxes differant colours.
    By excelu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2010, 02:22 PM
  7. Replies: 2
    Last Post: 12-11-2005, 01:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1