• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search suggestion drop-down list

Hi I am using the Excel 2013

I am allocation to audit person for a location with date, but I filled every time manually filter from "Master Data" sheet for

Main list, Sub-list 1, Sub-list 2

I am trying in "Working" sheet name

1st Match on "A2" (State Name matched, then District Name Show)
E.g.

If I type in A2 is Delhi, I type in B2 as the word "Delhi ", it shows B2 search suggestion drop-down list from "Master Data" Sheet...

Delhi
East Delhi
New Delhi
West Delhi



2nd Match on "A2" and "B2" (State Name and District Name matched, then City Name Show)
E.g.

If I type in A2 is Delhi, If I type in B2 is Delhi, I type in C2 as the word "Delhi ", it shows C2 search suggestion drop-down list from "Master Data" Sheet...

Delhi
New Delhi


Thanks for the Advance, Kindly provide the Formula or Data Validation for itself
 

Attachments

Top