Help Help Help

[AdriaanGerber]

Hey Guys. Im looking to use excel in a basic stock check in and check out manner. To do that I would like to setup a a inventory page containing all the data of our stock. Each stock item will have a "bar code".This Barcode will then be scanned and entered on to another page. When scanned and entered into the code area i would like it to then list the stock item in the description line. Is this possible and how.

Just to show what I want

Code Description Department
VT080801 JBL VT4888 - #1 Sound

This is the basic line of my inventory

Then when I scan my code it pops up in the code section and lists the equipment. Please help

 

[SteveO59L]

Have a look at vlookup()

 

[AdriaanGerber]

Thanx mate

 

[AdriaanGerber]

Okay Second Question...Can someone please explain VLOOKUP

 

[al_b_cnu]

Hi,

If your inventory is in sheet 'Inventory' & looks like:

Book1
	A	B	C	D
1	Code	Description	Department
2	VT000180	Desc VT000180	Dept B
3	VT001126	Desc VT001126	Dept C
4	VT001908	Desc VT001908	Dept C
5	VT002279	Desc VT002279	Dept B
6	VT002623	Desc VT002623	Dept C
7	VT002650	Desc VT002650	Dept B
8	VT002897	Desc VT002897	Dept A
Inventory

Continued ...

 

[al_b_cnu]

... continued

Try VLookup as follows:

Book1
	A	B	C	D
1	Code	Description	Department
2	VT001908	Desc VT001908	Dept C
Sheet2

Formula in B2 is =VLOOKUP($A2,Inventory!$A:$C,2,FALSE)
Formula in C2 is =VLOOKUP($A2,Inventory!$A:$C,3,FALSE)

 

[Yard]

Okay Second Question...Can someone please explain VLOOKUP

Hit F1!

 

[AdriaanGerber]

Thank man. Okay so if I use this formula and my inventory is in order. Will it matter what I scan out when. If Item39 gets scanned out before Item8 will that affect anything

 

[al_b_cnu]

Hi,

The formula will just return the lookup result for the code you entered in cell A2.

You can, of course, copy down the formulae in B2, C2 to the cells below and enter more scan codes into A3 onwards.

 

[Yard]

Remember, if the code you are looking up appears >once in the list then the VLOOKUP formula will just return the relevant info for the first one it finds.