There is a sample Excel "inventory" example spreadsheet that you can
download from the following web page:

http://www.taltech.com/freesoftware/Inventory.htm

The file that you download is an Excel workbook that contains a
special VBA coded "lookup" function that will search down column A in
the workbook looking for a number that you can enter either with a bar
code scanner or on the keyboard and if it finds a match, it will
highlight the row containing the matching number. You should be able
to easily modify the VBA code to do exactly what you want to do.