Index match with part of the text as condition

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Re: Index match with part of the text as condition

    First the file you attached is referencing another file. This is fine for the final file that you use, but it does make it difficult to fix issues from our side. Instead set up a dummy sheet in the file you are attaching. Second for what you are trying to do you will have to add an if statement wherever you are trying to only grab the data that matches a certain criteria. int eh code I have only changed one part, which is highlighted in yellow, but you will need to fix the rest. Please be aware that this will turn the formula into an array formula which has{} around the whole formula. In order to get this once you have finished the formula press ctrl+shift+enter. =INDEX('G:\CLGD-Techniczny\Faktury techniczny\[Faktury kosztowe.xlsm]FAKTURY DT'!M$2:M$1048576,MATCH(1,if('G:\CLGD-Techniczny\Faktury techniczny\[Faktury kosztowe.xlsm]FAKTURY DT'!J$2:J$1048576=F2,'G:\CLGD-Techniczny\Faktury techniczny\[Faktury kosztowe.xlsm]FAKTURY DT'!J$2:J$1048576))*((MID('G:\CLGD-Techniczny\Faktury techniczny\[Faktury kosztowe.xlsm]FAKTURY DT'!$D$2:$D$1048576,7,4)="2015"))*('G:\CLGD-Techniczny\Faktury techniczny\[Faktury kosztowe.xlsm]FAKTURY DT'!U$2:U$1048576=A4),0))
    I hope this helps. If you want some examples of array formulas do a search in google for "Excel Array Formula"

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!