Index match with mid function

[eurano]

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

 

[63falcondude]

I am unable to view your attached file without logging into the other forum. If you can create an example and post it here, we should be able to help you. That being said, I recommend making helper columns to build your formula. For example, make a column to extract 2015 from a string and another to use that value in your index match formula. This makes building large/complicated formulas easier.

 

[63falcondude]

Something like this.

	A	B	C	D	E	F
1	String	Value	Mid		Letters in String	Match
2	123 ABC 456	4	ABC		ABC	4
3	1 BCD 46	3	BCD		BCD	3

<tbody>
</tbody>

C2 =MID(A2,FIND(" ",A2)+1,3)
F2 =INDEX(B:B,MATCH(E2,C:C,0))