What formula is like match but returns Duplicates instead of just the first instance
example i have a Dynamic list that I need to look up all the names in
Jon
Pal
Pet
Sam
the lookup area is
Jon
Pal
Sam
Pet
Kim
Jim
Pal
Sam
kim
Jim
i need to return 1;2;3;4;7;8;
thanks
Bookmarks