Hello everyone!
In a sheet i have the following:
A2=Joe; A2= Jack; A4= John and for each name there is a recommended Name list in B2:B4 (Fruitlist;Vegetableslist;Dairylist)
A2:A4 is defined as Names
G2:G5 is defined Fruitslist
L2:L4 is defined Vegetableslist
Q2:Q4 is defined Dairylist
In B7...