+ Reply to Thread
Results 1 to 2 of 2

Need help, date specific data from multiple row and columns

  1. #1
    Registered User
    Join Date
    06-14-2020
    Location
    Mumbai, India
    MS-Off Ver
    Office 2007
    Posts
    5

    Need help, date specific data from multiple row and columns

    Hello:

    In the attached excel file, result is required in "Sheet1" tab, column G based on combination of data available in columns A, C, D, and E. The data will be fetched from "lsspecific" tab.

    Please see below example from line item 1 in the, excel sheet.

    1: Event date is 1/1/2020, so formula must search in "lsspecific" tab, A and B columns for date range.
    2: RS is 997, so formula must search in "lsspecific" tab, C column.
    3: LS is SELF, so formula must search in "lsspecific" tab, D column.
    4: Amount is 250000, so formula must search in "lsspecific" tab, E and F columns for amount range.

    Result will be the value from coumn G in "lsspecific" tab

    Thanks in advance for all the help.
    Attached Files Attached Files
    Last edited by dineshchaure26; 06-15-2020 at 05:21 PM.

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,829

    Re: Need help, date specific data from multiple row and columns

    Try this in Cell G2. You'll probably need to enter it as an Array Formula so enter the formula with Ctrl+Shift+Enter. Then copy it down.

    =INDEX(lsspecific!$G$2:$G$56,MATCH(1,((A2>=lsspecific!$A$2:$A$56)*(A2<=lsspecific!$B$2:$B$56)*(C2=lsspecific!$C$2:$C$56)*(D2=lsspecific!$D$2:$D$56)*(E2>=lsspecific!$E$2:$E$56)*(E2<=lsspecific!$F$2:$F$56)),0))

+ 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] date specific, from multiple rows and columns
    By dineshchaure26 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-14-2020, 06:56 PM
  2. Get data from specific columns with multiple conditions
    By CinnamonCherie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-11-2020, 01:37 PM
  3. Copy and paste multiple columns with specific date to another worksheet
    By manebobbymo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2019, 11:19 AM
  4. Count Unique Names across multiple columns for specific date
    By KattieSpencer in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-22-2016, 10:07 PM
  5. [SOLVED] macro needed to extract specific columns out of multiple columns with their row data
    By genetist in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-07-2014, 12:49 AM
  6. Replies: 2
    Last Post: 04-04-2013, 12:26 PM
  7. remove columns with specific data in multiple sheets
    By tanakwagu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-29-2010, 07:29 AM

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