View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
clubman clubman is offline
external usenet poster
 
Posts: 1
Default want to use a barcode scanner in excell need formula "if" "then" ?

I have a scanner that i can ues in excel. it will place a number into cell
A1. What i need it to do is lookup that number and place the description
into cell A2. and then add that quanity of the items that match that
description into one cell for that item, like an inventory program would do.
i believe there is a formula for this and i've tried but get errors in the
formula all the time. just learning some of the commands but need alittle
help. former lotus user. thanks