I have attached a sample solution. V1 contains the name of interest (in this case Michael Whitehead). Column W contains a unique marker for each of the "Whitehead" rows. X2 picks one of these markers at random. X2 uses the typical MATCH-INDEX to get the equivalent value from column Q.
Bookmarks