+ Reply to Thread
Results 1 to 3 of 3

How to display results in a column in a source table according to criterias?

  1. #1
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    175

    How to display results in a column in a source table according to criterias?

    Hello to the community.

    I am working on the file "Test Lucas".

    I have two tables:
    - Table 1 (A1:E3) > source table
    - Table 2 (H1:J5) > target table

    I would like to get the results in the column E.

    For example, I am looking in the target table H1:J5 according to the criterias of the source table (the value 22000 with the date 19/02/2020) and display in the source table the results.

    Thank you for your help.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: How to display results in a column in a source table according to criterias?

    Hi,
    maybe this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Diana Tanase


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

  3. #3
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2404
    Posts
    1,259

    Re: How to display results in a column in a source table according to criterias?

    Another option in E2 and copy down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Good luck!

+ 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. Replies: 5
    Last Post: 07-01-2019, 08:01 AM
  2. Replies: 1
    Last Post: 05-11-2018, 02:54 PM
  3. [SOLVED] Check if value exists in column, and display certain value matching 2 criterias
    By Andrewjs in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-09-2017, 02:02 PM
  4. [SOLVED] formula to display pivot table source range
    By iracknback in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-19-2016, 06:28 PM
  5. Need Formula to display pivot table source data
    By Don S in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-19-2016, 05:13 PM
  6. Replies: 0
    Last Post: 03-10-2013, 04:19 PM
  7. Display file name of pivot table source
    By mlk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2009, 11:36 AM

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