Drop down list and matching drop down selection to other data

Hello, I have made a drop-down list based on the GO Ontology groups (unclassified, rab etc..). On the 'Serach Sheet' the list gives you the Entrez IDs under that particular GO Ontology. I would like when an ID is selected to display the Gene Symbol, MGI Gene/Marker ID, Ensembl ID, and a "Yes" if the Entrez ID is mapped under 'GO Ontology ID is Mapped' and a "No" Entrez ID is mapped under GO Ontology Unmapped IDs.

I have attached the excel file.

Hopefully we can figure this out! I look forward to the suggestions.