Good Day!!

I have two lists - IDs and company names. I have the list of IDs set as a conditional format drop down. What I would like to do is, when an ID is selected autofill the adjacent cell with it's associated company name (presumably from another list). Is this possible?

Thank you,

Paul