Help with Excel drop down list

Hello

I need you help.

My first document is called database.xlsx, where I have my data of countries.

My second document is called FinaleDocument.xlsx, where I wish to, when is choise ID for example a1, that data (state, abbreviation, postal code) is copying form database.xlsx to certain field in FinaleDocument.xlsx

I hope that you understand.

This two document are in attachments

Use vlookup to copy <State Abbreviation Postal Code>

FinaleDokument.xlsx‎
column C2 is a1
at column D2=vlookup(C2,table array you want lookup<database.xlsx‎- A2:D5>, return index < 2 >, false)

Thanks for help.

I wish, when I choose from drop-down list (certain ID ) in Finale Dokument, that the value from database will be copy.

Thanks wqnqq3, could you please do that in my excel document.

I am not so good in excel.

Thanks

Thanks wqnqq3, could you please do that in my excel document.

I am not so good in excel.

Thanks

FinaleDokument(EDIT).xlsx

Hope this is what you mean.
For easy job, i combine the 2 workbooks.
database.xlsx is at worksheet "List2"

yes thank you very much, is not so difficult, but you have to have ideas and knowledge.

Could you please send me document database.xlsx, that I now exactly how to set List2

Thanks. Can I gave you some points for solve my problem.

Sorry I forgot something.

You have god idea but not perfect. I wish to have this in two different document.

Just as in the attachment.

You can do it yourself. Is really simple.
use VLOOKUP( value, table_array, index_number, [false or true] )

For your file:
D2=VLOOKUP(C2,select the range from workbook(database.xlsx),2,FALSE)
E2=VLOOKUP(C2,eg: [database.xlsx]List1!$A$2:$D$5,3,FALSE)
F2==VLOOKUP(C2,eg: [database.xlsx]List1!$A$2:$D$5,4,FALSE)

Please, please could you do that and send me this two files. I thank from the bottom of my heart

Thanks

I hope so, but the vlookup will catch my directory(C:\Users\ABC NAME\download\) .
So it is different from your directory.
you just change the red color that i reply you at post#10.

I did it. Before (before you help me) I tried with vlookup, but my knowledge is not enough.

Is this also possible with drop-down list ? or this is (your idea) best solution for my problem.


Thanks

Just one idea.

Now is in my file database.xlsx my first column ID.

Is possible in file FinaleDokument.xlsx , when I write ID (for example a1, wich in database.xlsx mean Alabama, Ala. AL) i become some message, that this a1 is Alabama (I will hide column Alabama, Ala, AL in document FinaleDocument.xlsx)

Somewhere determine, when a write a1 and I go over with mouse, I become message on meaning (what is a1)

I hope is well explained.

FinaleDokument.xlsxdatabase.xlsx
I hope this 2 files help.
Which file you need do drop down list?
#10 no really understand.

The file FinaleDokument, column ID. Here I wish to choice (a1, a2, a3, a4) from drop down list.

Thanks

Now about my #10 questions.

I possible to define file FinaleDokument for example column ID, value a1, that when I go over this field I see some message. This message I predefine somewhere.

Thanks

Anybody have Idea.