Have you tried using Application.Match to find the row in A that the id is in?

You could then use that to populate the other controls.