Dropdown list // VLOOKUP using an external file as reference question

[jlg_silva]

Hi guys, Happy New Year!

Well, I'm creating a template for a Student Transcript which I want to simplify the jog of filling it up.

What do I have today:
- An unique file with the below formula to autocompelte a Subject Name columb, based on Subject Code provided in its column.
=IF(ISNA(VLOOKUP(C4,DISCIP_CODE,2,FALSE)) = TRUE, "", VLOOKUP(C4,DISCIP_CODE,2,FALSE))
- the DISCIP_CODE list in the formula is a named list, created in another worksheet.


Attached we have two files:
- Subject_Codes.xlsx - a workbook which is being used as a "database" of Disciplines and its corresponding code.
- Transcript.xlsx - Consider this as being the student transcript, which would use the other file (Subject_Codes.xlsx) as reference to autocomplete the fields.

What I would like to do:
- Transcript.xlsx column "SUBJECT CODE" create a dropdown list/combo and use the codes from Subject_Codes.xlsx/SUBJECT CODE. The user would choose the Subject Code based on codes we have in the "database"
- Transcript.xlsx column "SUBJECTS" would autocomplete based on the code provided in the cell "SUBJECT CODE"

Just in case, I have indicated in the cells of Transcript.xmls file, what I would like to do.

Tks a lot for your help once again.

Cheers
Joao Luis