+ Reply to Thread
Results 1 to 8 of 8

Getting Data based on Condition

  1. #1
    Registered User
    Join Date
    06-30-2023
    Location
    India
    MS-Off Ver
    Student version 2019
    Posts
    5

    Getting Data based on Condition

    Hello, I hope you doing good

    I have an issue see the attached image. It has 3 rows Username, Reporting, and date. now I want to see what danu66 posted on 8 August 2023. This is data where an employee reports what he will be doing every day so the data will be updated daily, which means the name of the employee (the name is unique) will come every day. I want to get the data of a person on a particular data how can I do that? Please help
    Attached Images Attached Images

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.90 for Mac MS 365
    Posts
    8,583

    Re: Getting Data based on Condition

    first off, you have 3 columns, not rows, but to match two variables, are you planning on putting the variables in cells or are you wanting them incorporated into the formula?
    example, MATCH ("danu66"... or MATCH (G2...
    where G2 (and likely H2 for date) would be where you would be putting the name (and date in H2) you want to match on?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    08-14-2023
    Location
    West Bromwich, England
    MS-Off Ver
    2016
    Posts
    3

    Re: Getting Data based on Condition

    VLookUp Would be my guess to start with

  4. #4
    Registered User
    Join Date
    06-30-2023
    Location
    India
    MS-Off Ver
    Student version 2019
    Posts
    5

    Re: Getting Data based on Condition

    Thanks for the reply,

    okay so I will create one more sheet and this above pic will be my source of data, I want to get the data of a person in that sheet only.
    . I used xlookup but the issue is I don't know how to put two conditions like I want to search danu66 only of a particular date so there are two condition one is of name and other is date if that matches then only give me the reporting cell as a result of that person of that date in a new sheet cell
    Last edited by shubhamdeokule; 08-15-2023 at 01:22 AM.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    87,931

    Re: Getting Data based on Condition

    There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  6. #6
    Registered User
    Join Date
    06-30-2023
    Location
    India
    MS-Off Ver
    Student version 2019
    Posts
    5

    Re: Getting Data based on Condition

    Okay

  7. #7
    Registered User
    Join Date
    06-30-2023
    Location
    India
    MS-Off Ver
    Student version 2019
    Posts
    5

    Re: Getting Data based on Condition

    the issue is that I im getting data of reporting if I mark danu66 as lookup but I want to lookup for two condition one for name and other of date

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    87,931

    Re: Getting Data based on Condition

    Waiting for a sample workbook.

+ 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. Fetch Data Based On a Certain Condition
    By wedzmer in forum Excel General
    Replies: 3
    Last Post: 08-23-2022, 04:42 PM
  2. Filter data based on value and condition
    By Nicolantonio in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-28-2020, 04:40 AM
  3. Data Validation based on a Condition.
    By Quasar82 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-30-2017, 05:06 AM
  4. Insert data rows based on a condition for measured data
    By JosipK in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2015, 02:09 PM
  5. Extracting Data Based on Yes or No Condition
    By leowyatt in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-19-2013, 09:02 AM
  6. Getting a row of data based on a condition
    By jhsiao in forum Excel General
    Replies: 7
    Last Post: 08-14-2012, 02:36 AM
  7. Select worksheet based on condition & populate cell based on condition
    By beth1069 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2011, 01:27 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