urgent help for a newbie

[ocoste]

I need help with excel. I have a product list in excel where products are
are Identified with a four digit code. E.G.

Code Product Desc Net VAT
Total

2354 Bleach General Cleaner £10 £1.75
£11.75

Lets call this the master list, it has 400 entries. I want to be able to
produce customer quotes on subsequent worksheets within the workbook. I
would like lines to 'autocomplete' after entering the product code alone. I
do not know how to link new sheets to the master sheet with the product list.
I am not an advanced user so any help in 'baby steps' please? Thanks.

 

[Max]

You can achieve what you're after with either VLOOKUP or INDEX/MATCH

Try Debra's nice coverage on VLOOKUP or INDEX/MATCH at her:

http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study