Help with implementing a customer finder?

[hm06120]

Hi all. Attached below is an image of a customer finder I am planning on implementing into a system being developed whilst using customer records.

Essentially, the idea is if a person forgets their order number (last field of picture 1), they can enter all of the relevant details into the ID, First Name, etc fields via drop down menus for each field.

How would I go about having the feature to be able to input 1 piece of data into one of the fields and have all of the other relevant data come up automatically, e.g. entering the ID number 1 and having all of "Jane Bryant's" relevant information come up.

Ideally I would like it so that any field that information is entered into leads to all of the other fields being filled in automatically using the relevant details from the table. Thank you.

Ps. firstly, the details are fake (if that's a concern), secondly, the fields that are filled in are not related, they are all as of yet just independent drop down menus.Untitled.pngUntitled2.png

[hm06120]

Attached the document.

[hm06120]

Yeah so basically, assuming all of the fields are blank (ID, First Name etc) i would like to be able to fill in any one field and have all of the other fields automatically be filled in. E.g. I enter the Last Name Davis and all of "John Davis'" details for every other field pop up.

[Richard Buttrey]

Before moving this to the VBA MAcros forum as Glenn has suggested, what about some data dependent validation drop down lists. Isn't that a potential option?

[hm06120]

Sorry, I'm honestly far from experienced with Excel. How would that work and what would I have to do to get it done?

[Richard Buttrey]

Take a look at Debra's Contextures web site See here.

You'll need to keep vertical lists of customer names, email addresses, post codes etc. I'd be inclined to keep your current Customer records sheet and list the values in lists on another sheet.

The idea is that one drop down list can take its values from a choice in another drop down.

[hm06120]

Regardless of whether this works, thank you so much for the help.