Multiple Criteria

[Mr Dean]

Can you see if you can help me with this Excel issue,
What I am trying to do is:-
If the value in column D is in column C then output the corresponding column E value into Column A.
I have tried using the formulae which is in cell A2 but when I copy it down nothing happens??

Image attached.

Kind Regards

 

[FormR]

Hi, here is an option you can try - note, for efficiency reasons you should avoid using full column references with this formula.

Book1
	A	B	C	D	E
1			Title	Part	First day
2	11-Sep		PV GQA-2019-052-001	52	11-Sep
3				64	19-Nov
4				62	05-Nov
Sheet1

Cell Formulas
Range	Formula
A2	A2	=LOOKUP(1,-SEARCH($D$2:$D$4,C2),$E$2:$E$4)

 

[Mr Dean]

Absolute star. Worked perfectly. Much appreciated