Formulating Columns

I work at a warehouse and I need to keep track of the trailers in and out. I want to be able to input a trailer number and have the license tag of that trailer generate into the neighboring cell from ...