Lookup Based on Keyed Entry


I work for a manufacturing facility and we want to use Monday on our line. We have a scanner that we would like to be able to scan a barcode and the result of the barcode does a lookup against another board to return a value. I have seen the lookup function, but it requires that you select the item from the previous board in a drop-down. Is there a way that I can type (or have a scanner input) data into a column, and have a second column do a look up.

What I have on one board is serial information with vendors, and on the working board, someone will scan one of those serials and it needs to return the vendor. Is this possible with Monday?