Hey all,
Hopefully a simple question for you lot but unfortunately not for me!
=IF(INDEX(T:T,MATCH(E5,AF:$AF,0))=H5,"Yes","")
=IF(INDEX(S:S,MATCH(E5,AF:$AF,0))=G5,"Yes","")
I have the above formulas in two different cells but I'm wanting to combine them both together. So that if both are...