fakiru2012
New Member
- Joined
- Dec 1, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello,
I'm trying to match values from a column based on the values from other cells that are on the same row with the values. I have the example below. I'm trying to match the value from column E which have the same amount, date, flag and document. The result i wish is in the second picture. I tried with a formula on another column to extract the associated account: " =IFERROR(IFERROR(INDEX($E$4:$E$23;MATCH(1;($G$4:$G$23=F4)*($C$4:$C$23=C4)*($D$4:$D$23=D4);0));INDEX($E$4:$E$23;MATCH(1;($G$4:$G$23=SUMIFS($F$4:$F$23;$C$4:$C$23;C4;$D$4:$D$23;D4))*($C$4:$C$23=C4)*($D$4:$D$23=D4);0)));INDEX($E$4:$E$23;MATCH(1;($G$4:$G$23=F4+F5+F6)*($C$4:$C$23=C4)*($D$4:$D$23=D4);0)))" but it takes a lot of time as I have a workbook with 200K+ lines. After i applied this formula I had to proccess the information manually (filters/copy/paste) to make sure that i'm not double anything. Is there any way to make it more easier?
I'm trying to match values from a column based on the values from other cells that are on the same row with the values. I have the example below. I'm trying to match the value from column E which have the same amount, date, flag and document. The result i wish is in the second picture. I tried with a formula on another column to extract the associated account: " =IFERROR(IFERROR(INDEX($E$4:$E$23;MATCH(1;($G$4:$G$23=F4)*($C$4:$C$23=C4)*($D$4:$D$23=D4);0));INDEX($E$4:$E$23;MATCH(1;($G$4:$G$23=SUMIFS($F$4:$F$23;$C$4:$C$23;C4;$D$4:$D$23;D4))*($C$4:$C$23=C4)*($D$4:$D$23=D4);0)));INDEX($E$4:$E$23;MATCH(1;($G$4:$G$23=F4+F5+F6)*($C$4:$C$23=C4)*($D$4:$D$23=D4);0)))" but it takes a lot of time as I have a workbook with 200K+ lines. After i applied this formula I had to proccess the information manually (filters/copy/paste) to make sure that i'm not double anything. Is there any way to make it more easier?