This is so difficult for me to explain... I have 10 drop down boxes per sheet, and one sheet per day that lists all of our products, 10 different times. I found a formula online that will make suggestions for the most likely product based on the letters typed. I will post the code that I used...

=--ISNUMBER(IFERROR(SEARCH('Monday Report 1'!$A$5,DropMon1!A2,1),"")) which then returned a value which the next column used...

=IF(B2=1,COUNTIF($B$2:B2,1),"") this gives suggestions to the next column with this code

=IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($C$2:C2),$C$2:$C$100,0)),"") The final line of code, which returns a name, is how I defined the value of all of my names.

=$D$2:INDEX($D$2:$D$100,COUNTIF($D$2:$D$100,"?*"))