• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to put formula/ function to get Two names match with multiple names and repeat n times


Dear Forum ,

tried Index and match , index small rows ,........ But I am not getting desired value in ms office 365
I have two values and n names it should match with one name and repeat how many times that name repeats and go to next name and repeat like ....

I have tried many but not worked , please any one help me , I have attached sheet with tried formulas

thank you in advance