Creating Invoices and intergrating barcodes and information

Hi, I'd really like some help and to know if this is possible. It is possible to upload barcodes into Excel along with a description of what the barcodes represent i.e the name of a stock item and ...

excel

Formulas and Functions

Haytham Amairah
Feb 01, 2018
The barcode is a unique identifier, so you can use some lookup functions such as https://www.google.jo/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwj28rOq-YTZAhXJwVkKHb9oAMoQFggnMAA&url=https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FVLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1&usg=AOvVaw1iEZFbzg6YJQNqT2AKp9Lr to get product's info based on this identifier and return it to the invoice template.

Haytham Amairah

Silver Contributor

Feb 01, 2018

The barcode is a unique identifier, so you can use some lookup functions such as https://www.google.jo/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwj28rOq-YTZAhXJwVkKHb9oAMoQFggnMAA&url=https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FVLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1&usg=AOvVaw1iEZFbzg6YJQNqT2AKp9Lr to get product's info based on this identifier and return it to the invoice template.

Bio Sculpture

Copper Contributor

Feb 05, 2018

Hi Haytham,

Thank you so much for pointing me in the direction of VLOOKUP - this is exactly what I need.

Thank you once again.

Forum Discussion

Creating Invoices and intergrating barcodes and information

Resources