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!

Ηι

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

Regards