=index(b2:b5,match(aggregate(15,6,len(a2:a5)/isnumber(search(d2,a2:a5)),1),len(a2:a5)/isnumber(search(d2,a2:a5)),0))
=index(b2:b5,match(aggregate(15,6,len(a2:a5)/isnumber(search(d2,a2:a5)),1),len(a2:a5)/isnumber(search(d2,a2:a5)),0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks