[b]Create a Search section on Excel Document[/b]

[cruiser102]

Good Afternoon,
I have recently created a database that will store vehicle registration numbers.

I would like to add an area on the excel sheet where i can type in a registration number and it will check the stored registrations and if there is one already saved with the same one it will show this and its details on the screen.

Can anyone assist with this please? Ideally it needs to be a textbox with a button that you can search with.. Preferably a userform?

I have attached my Excel file

Kind Regards

[johncassell]

Im sure you have your reasons but why not just use the standard Excel Find function?

[cruiser102]

Because its for people who are not used to really using computers and it would be much easier for other people to just simply enter the details in a box and search on the 'home' screen.

..... Any ideas?

[alski]

Hi,

Is this an option? A simple vlookup seems to be what you are after?

Alex

[EdMac]

Just use VLOOKUP?

[cruiser102]

Thats Great!! Fantastic for this document,


But how do you make one of these? - I also have a Persons Details system where i would like to be able to search, surname, and DOB.. Could i use the same setup?

Thanks Very much

[alski]

just be aware that the named range I used only covers a certain area on the list

Go to Insert... names... define and select columns A:G

This is completely transferable... just use the vlookup function - I've complicated mine by using the match function to lookup the title in column d. You can just replace this with a column number

=VLOOKUP($D$15,DataTable,2,FALSE) will pull back the Make

[cruiser102]

Thanks, Just to add another question to the thread regarding searches how can i make a search to lookup the following:

I would like to search for the Make of the vehicle and the date it was seen. How can i programme this to return the matches? Preferably a userform or area on spreadsheet

Regards
Mark