Results 1 to 4 of 4

How to find a result according two conditions and one parameter?

Threaded View

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

    How to find a result according two conditions and one parameter?

    Good evening.

    I am working on the file "Copie de DSM DRAFT Agup PH2".

    I have one tab "Agup PH2" with the following structure:
    -Column H:Test
    -Column I: Item
    -Column U: M Cumm.(JAN-2025)
    -Column V: Expected result

    I have a second tab "Fichier Suivi TAS" with the following structure:
    -Column J: Test
    -Column W: Item
    -Column AF: ITD

    The objective is to get in column V of the tab "Agup PH2", the result displayed in the tab "Fichier Suivi TAS", column AF.

    Fo example, in the tab "Agup PH2",if I take the line 3, i see that the Test is 4100003817 and Item 00003. So I watch in the tab "Fichier Suivi TAS", the column J and search for "4100003817", then I search on the column W and search for "00003". The result with these 2 conditions is displayed in column AF with "173470.

    I put this formula and it worked

    Formula: copy to clipboard
    =INDEX('Fichier Suivi TAS '!AF:AF; EQUIV(H3 & I3; 'Fichier Suivi TAS '!J:J & 'Fichier Suivi TAS '!W:W; 0))


    But I would like to add one parameter for my formula in the column V of the tab "Agup PH2".

    I would see a different calculation for the Test 4100004772.

    Indeed, I have Test "4100004772" and Item "00001", I would like to search in the tab "Fichier Suivi TAS" for Item "00001+00003".
    I could see 119 959,86 (36 631,86+83328,00) instead of 36 631,86.
    Indeed, I have Test "4100004772" and Item "00002", I would like to search in the tab "Fichier Suivi TAS" for Item "00002+00004".

    Can you help me on that?

    Tx.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Power query parameter to select result
    By Dicken in forum Office 365
    Replies: 5
    Last Post: 05-22-2024, 02:33 PM
  2. [SOLVED] Show left chars of xlookup result with conditions on return result
    By Tech980 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-11-2023, 07:15 AM
  3. [SOLVED] Find result in Data Table by multiple conditions
    By AlexinJap in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-27-2022, 08:30 PM
  4. [SOLVED] Altering code to find similar parameter
    By ell_ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2018, 04:37 AM
  5. [SOLVED] Function IF to find in three conditions and to give a result
    By davide2574 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-08-2016, 03:41 AM
  6. Maximum Result with Parameter
    By Tbalot in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2015, 12:44 PM
  7. Find All Method - Empty Parameter
    By ac_surf in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-05-2010, 11:49 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