Barcode input to match cell and return the value of another cell

[frostygent]

Hi I am new to the forum and to macro's and advanced excel formula's. I think what I am looking to do is possible in excel, but I definitely need help

I get a text file daily for routed deliveries containing a barcode, name, address and phone number that I convert into csv and then upload it into a route optimization software. after optimization is complete it has assigned packages to drivers and I export it to excel and print. My sorters are having a difficult time reading the addresses on the packages and assigning them to the proper driver, so I am trying to come up with a way to help them.

My idea is that I can import the barcode as a custom field into the route optimizer and then when I export it, that barcode field will still be associated to that order. I want to scan the barcodes of the package into column C which will reference all of the barcodes in B and when it finds the match, it will return the value in A, the driver assigned to that particular package. This way my sorter will just have to scan the packages and throw it into the proper bag for the driver instead of having to visually scan the printed manifest to match.

Thanks in advance, and please let me know if I need to clarify; I tend to speak anti-tech

[frostygent]

Is it that this is not possible or do I need to clarify better?

[stnkynts]

It is too challenging to figure out what you are doing/needing based upon your post. Submit a worksheet with very clear before and after examples on what you want.