Re Excel

Reillo

Hi All

I have 2 workbooks in excel.
1 for master stock
1 for invoices

I want to, in my invoice workbook enter a code and have the description come up automatically from my Stock workbook. I have been trying for ages to do this mainly to streamline and save time can anybody point me in the right direction before i go mad

mark renton

personally I would use Access for data and sql for querys - but vlookup i believe is yer man and is one of the reasons I would use Access

Also if you post this in Programming forum they may be in position to assist further - also google vlookup for tutorial

Reillo

Cheers john,

Unfortunately I dont have Access, what is vlookup, sorry I am a novice

Shane O' Malley

VLookup is the way.

Not sure which version of Excel you have but in 2003 it goes like.

=VLOOKUP(B1,Sheet2!1:65536,2,FALSE)

Where you are asking it to:

1. Look at the value in Cell B1
2. Go to Sheet 2 and search for the value found in B1 above. (It searches the first column)
3. Return the Value in Column 2 of Sheet 2 on the line you found B1 in
4 False is there so that it finds the exact match rather than the closest match.

Explaining it badly but there is a wizard in Excel 2003 which will guide you through it.

Shane

Tim M-U

you can search your excel document, Ctrl + F . all you need to do is have some kind of account no for each customer

Reillo

cheers people made some progress on it today..


will go back again on Monday

Have a good weekend;)
thanks again