Hi

I need to find a value in column E but it has to meet 2 different
criteria

the value in column A and column C must match before

so if this is wat it looks like

A B C D E
1 X TR X 3.1
2 X TR X 3.1
1 X TL X 3.1

I need to find 3.1 only when Column A is 1 and Column C is TR

Thanks in advance