Vlookup question

[stevesunfold]

hi guys
fairly new to excel but can find my way around bit

trying to make up a simple spreadsheet that will recognise all the stock that i keep in my stock room.
basically im looking for the spreadsheet to supply all the information after i have entered the product code.
so im looking for any help possible on the lookup function and how it works

steve

[NBVC]

Vlookup() should do the trick if you set up a table.

In the table make your first column a list of product codes and put all relevant info in the adjacent columns.

let's say you placed this table in Sheet2 within Range A1:D100


Let's now say you enter your product code in Sheet 1, cell A1

in B1, enter =Vlookup(A1,Sheet2!$A$1:$D$100,Column(B$1),0) and copy that over to column D.

You can copy this formula down to get relevant info if you are entering multiple codes.

P.S. Can you please change your title to something more descriptive of your problem before the moderators come on the attach....

[stevesunfold]

hi and thanks for the superfast reply

much appreciated

there will be about 400 different product codes each with there own different descriptions and unit price each

i want the spreadsheet to load the descriptions and unit prices in once i have entered the product code
so for example in column a i will have the date ( by the way is there anyway i can have the spreadsheet enter the date automatically as soon as i put a product code in column b? ) column b will be product code , column c will be the description ( obviously i will have to manually type these in for the very first time ) and column d will be the unit price

thank you
steve

[NBVC]

As I mentioned, it is best if you have a separate table with all the necessary info in it.

Then when you enter a product code, the Vlookup() will get the description and unit price from the table. If you enter a quantity too, then you can also include a formula that will get you the extended price.

Btw: You can use a =Today() formula to get today's date, but that will update to tomorrow's date when you open the sheet tomorrow...so it's best to manually enter the date. (or use VBA event macros, which I am not great at.)

[stevesunfold]

thanks nvbc will give it a go tomorrow.
i could be back lol
im not exactly sure what vlook up works but will give it a try

thanks
steve