I am working from two worksheet.
Collection Worksheet is an input worksheet. I type in the gathered information. Column D contains a drop down list of names.
Information Worksheet contains list of student names (column e) and graduating year "Column D".

On the collection sheet next to the names, I want to autofill the graduating year.

I have used this formula, but it returns the wrong graduating year.

=LOOKUP(D26,'Individual names'!E20:E102,'Individual names'!D20:D102)

What am I doing wrong?