Forum

Notifications
Clear all

Lookup Two names match with multiple names and repeat n times

2 Posts
2 Users
0 Reactions
89 Views
(@sudarsan23)
Posts: 3
Active Member
Topic starter
 

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
regards
SUDARSAN

 
Posted : 17/04/2021 1:58 pm
(@catalinb)
Posts: 1937
Member Admin
 

Why in column D:

Anantapur is repeated 7 times
Chittoor is repeated 9 times?
 
Posted : 18/04/2021 11:08 pm
Share: