Combining Formulas
Results 1 to 3 of 3

Thread: Combining Formulas
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2018
    Posts
    39
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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
    Last edited by shakeregg; Mar 11th, 2019 at 09:23 AM.

  2. #2
    MrExcel MVP FormR's Avatar
    Join Date
    Aug 2011
    Location
    UK
    Posts
    6,058
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Combining Formulas

    Quote Originally Posted by shakeregg View Post
    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")
    [code]your code[/code]

  3. #3
    New Member
    Join Date
    Sep 2018
    Posts
    39
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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