+ Reply to Thread
Results 1 to 2 of 2

Barcode Scanning - Library

  1. #1
    Registered User
    Join Date
    Chesapeake, VA
    MS-Off Ver
    Excel 2010

    Barcode Scanning - Library

    I'm exploring the option of using excel to keep track of a small church library (<500 books/DVDs). I already have a barcode scanner, and I know that if I scan a barcode while my cursor is in a cell it will generate a series of numbers.... basically read the barcode. So I'm confident that I can scan a book or DVD's barcode to begin creating a library database.

    Here's my question: After I've completed scanning in barcodes and creating a database, is there a formula or something I can use to program the excel spreadsheet so that it will find the item I am looking for when scanning a barcode? Basically... can i program it to function like library automation software? I want to be able to scan a barcode to find that book or DVD within in the database I've created so that I can record check in/out dates & information. Anyone know how to do this???

    Thanks for any help/advice you can give!

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010

    Re: Barcode Scanning - Library


    I think you need, INDEX & MATCH functions

    You create the database and then assuming that the numbers from Barcode is in column A, then in column B, you will come to describe.

    Hope to helps you

    Attached Files Attached Files


    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1