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:
=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.
Bookmarks