# Thread: Combining Formulas Thanks: 0 Likes: 0

1. ## Combining Formulas

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

2. ## Re: Combining Formulas

Originally Posted by shakeregg
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")

3. ## Re: Combining Formulas

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!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•