Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
want to use a barcode scanner in excell need formula "if" "then"?
Hi,
In cell A2, you can adapt the following to your specific situation : =Vlookup(A1,YourDataTable,YourColumnNumberforDescr iption) HTH |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
want to use a barcode scanner in excell need formula "if" "then" ?
The feature you want is called the VLOOKUP formula..........it's uses like
this. First, you create a table somewhere out of the way.....the table being your list of numbers down one column and your list of descriptions in the column immediately to the right....say you used columns Y and Z.....then place this formula in A2 =VLOOKUP(A1,Y:Z,2,FALSE) Now, one thing you have to look out for, is that both the A1 value, and all the values in column Y have to both be either TEXT, or NUMBERS, and not just "look" like numbers, but actually have to be formatted as numbers. This difference often causes folks trouble with the VLOOKUP formula........try this, and post back if you have problems........ Vaya con Dios, Chuck, CABGx3 "clubman" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
want to use a barcode scanner in excell need formula "if" "then" ?
You can download a free sample Inventory program implemented in an
Excel spreadsheet from the following web page: http://www.taltech.com/freesoftware/fs_sw.htm Look for the "basic inventory tracking example on the above web page. The sample spreadsheet uses userforms and VBA code to do lookups in a worksheet to find and update data records. On Sat, 5 Jan 2008 18:14:00 -0800, clubman wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Why does excell switch my stock symbol "ACN" to "CAN"? | Setting up and Configuration of Excel | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |