Search Suggestion with formula not working

Dear All,

I've checked so many websites and able to get the formula for search suggestion in Drop-Down List with formula but couldnt able to understand how to retrieve only unique values

=IFERROR(INDEX('Total Export Orders'!E$2:E$26,MATCH(ROWS(V$12:V12),G$12:G$56,0)),"") - Will retrieve the values from raw data to data validation list as it is i.e., without removing duplicates

I've written formula as shown below to retrieve only unique values but not working.

=IFERROR(INDEX(INDEX('Total Export Orders'!E$2:E$26,MATCH(0,COUNTIF($V$12:V12,'Total Export Orders'!E$2:E$26),0)),MATCH(ROWS(V$12:V12),G$12:G$56,0)),"")

Best Regards
Anil

Originally Posted by nflsales

Where you want to show unique values only and what are your requirements

Please enter 12 in Models picklist of Receipts sheet and see it in the last rotor column in which it should show only 12 but it is showing 12mm, 13mm etc

Theres a problem with the formulaI written in this which is not pulling unique values.can you please make it correct?

let suppose if I select Rotor as item & if I type 12 in the Model Picklist & want to see only 12mm nothing else

another example is if I select Canopy in Item Picklist & if I type action, list with action in the word should appear in the model picklist.

This is what Im expecting here but somehow I say Im succeed and even dissatisfied with the values that are being displayed when I type something in Model picklist

Regards
Anil T