Forum Discussion
Creating Invoices and intergrating barcodes and information
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.
Hi,
I'll point you to these links, it's similar to what you want:
https://www.tec-it.com/en/software/barcode-software/office/excel/Default.aspx
https://www.youtube.com/watch?v=X211r3e4tPM
https://www.youtube.com/watch?v=yssnGacoTNA
Hi, Thank you for your help but its not quite what we are after.
Basically I need to be able to create invoices using information from a barcode.
Currently, if I just scan a barcode into an invoice template in Excel, just the barcode shows, I need the invoice to show when I scan a barcode, the name of the product, the price of the product and the quantity bought.
So I'm guessing I need to set-up all of this information on a separate excel sheet and have the invoice link to that information so that when I scan a particular barcode that's on that separate sheet, it draws all of the information into the invoice.
Is this possible and how do I link that information?
Many Thanks.
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.
Hi Haytham,
Thank you so much for pointing me in the direction of VLOOKUP - this is exactly what I need.
Thank you once again.
