Hi i cant manage to create index match formula (cell F4). One of the condition to meet by criteria is part of the text in Column D in another file wich should be equeal to 2015. I have never made such complicated formula so far so I decided to look for help. File is in the attachment -> link below:
Index match with part of the text as condition
Index match with part of the text as condition