So I have 2 sheets opened right now. The first is a list of subjects I need to work with, and the second is the entire database with all the info.

Is there a way to go through the entire database and find ONLY the subjects I need, and their corresponding info, that does not involve manually selecting, copying & pasting?

For example, my subject numbers are 2, 4, 5, 9. The database has eye colour for subjects 1 to 10. I only want the eye colour for 2, 4, 5, 9.

Thanks in advance!