Hello,
I would like to ask you for help with the creation of a database. For now I must link information from different excels spreadsheets or excel documents.
The idea is having 2 different documents:
- One containing laboratory data
- Another one containing some of this information + other parameters.

The input from the laboratory data is manual. An example would be:

Sample num Cl Br I
1234 1 2 3
12345 5 6 7

Then in the other excel spreadsheet when someone inputs a sample number (ex. 1234) there should be a function recalling the sample data and automatically filling the information on the corresponding cells.
Date Sample num something1 something2 Cl Br I
INPUT AUTOFILL AUTOFILL AUTOFILL
INPUT AUTOFILL AUTOFILL AUTOFILL


I am sorry but I am completely new in this so… an explanation for dummies would be mostly appreciated (or any helpful reference).
If you need any other information just let me know.

Thanks a lot!