Combining Formulas

[shakeregg]

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 Yes' it be a Yes otherwise it'll be a No.

Can provide more detail if needed.

Any help would be muchly appreciated!

Cheers

Matt

 

[FormR]

I'm wanting to combine them both together. So that if both are Yes' it be a Yes otherwise it'll be a No.

Hi, you could try:

=IF(AND(INDEX(T:T,MATCH(E5,AF:$AF,0))=H5,INDEX(S:S,MATCH(E5,AF:$AF,0))=G5),"Yes","No")

 

[shakeregg]

Perfect............. works a treat! Thankyou!

Although I've now encountered another slight problem but will have to start a thread as it's a different topic heading!

Cheers again!