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, 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.