Search Suggestion with formula not working

Dear nflsales/MarvinP,

Please refer the attached excel Receipts sheet for data validation list, which I'm trying to import unique values from Total Export Orders to data validation list as per respective header

Ex: When I select DownRod as item, respective column values from Export orders should be shown which should be unique.

I think it makes sense, if else let me know.

I referred below links for doing my tasks

for dependent data validation list:

https://www.ablebits.com/office-addi...ading-dropdown

for search suggestion in dependent data validation list:

https://www.youtube.com/watch?v=vkPoViUhkxU

for unique values in dependent & Search Suggestion list:

http://www.get-digital-help.com/2009...om-one-column/