Excel 2007 - Making a database

[»X«]

In my office there is a computer which holds a very old DOS database. Simply put, you put into it 3 letters and it will come back with the branch which our messages need to be delivered too. There is over 3000 letter combinations for us.

But being DOS its unstable and prone to crashing. Its also very complicated for the minions here to use.

I managed to export the whole database into a txt file which is the 3 letters seperated by a semicolon then the branch name.

Can I put this into excel and use some formula so all thats on the screen is an entry field, type in the 3 letters and bingo, the branch pops up?

Any pointers would be nice.

Also note, what I know about excel isnt worth knowing.

Our office also has Access 2007 also.

[S_Herbie]

Something like this?

SimpleList.zipFetching info...

[»X«]

^ Thank you!

Thats pretty much perfect. There is a few more columns to add which I shall tinker with at work tomorrow.

Is there a way to have a txt field and a button to find the code? Reason is there are people at the workplace who are terrified of technology. Asking them to double click and type then click away will be like pulling teeth.

[S_Herbie]

You don't need to double click to edit the cell, just type and press enter or pick from the dropdown list (validation).

You could add a textbox and button to either the sheet (or a form) or just prompt the user with an input box (see example)

SimpleList_V2.zipFetching info...

[p858snake]

You could also do this with access and then have it when you open the file have it display the form and restrict what menus they see, so you could have like a dropdown box or textfeild to search and have it display the information. and you can import all the information in from the excel file as well.