Autopopulate from list based on adjacent cell value

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

I've attached an example of what I'm trying to do.

On the tab (Worksheet), I have a dropdown in cells in column A. When a user selects a value (ID) from the drop down, I want the adjacent cell (ex. B1) to autopopulate with the corresponding company name. I have the ID list and Company names in the other worksheets.

Thank you, that works great!!!!!

I do get a #N/A in my B cells before entering something in my A cells, is there a way to suppress that #N/A?

nevermind, got it. thank you for the quick reply!!