Hi

I use Excel 2000

I would like to use a range name in a VLOOKUOP table

Presently I have 2 worksheets, the 1st one is called ORDER FORM and the 2nd
one is called ADD NEW COLOUR

The ORDER FORM sheet has a data validation list that uses a range name
called "COLOURS" which data range is $A$2:$D$347 on the ADD NEW COLOUR sheet.
This is so that when a new line is inserted into the data on the ADD NEW
COLOUR sheet that the validation box on the ORDER FORM sheet picks up the new
entry.

On the ORDER FORM sheet I have the following:

=VLOOKUP(D15,'ADD NEW COLOUR'!$A$2:$D$347,4))

(D15 is the cell that contains the validation list)

The problem I have is that when a new line of data is inserted into the ADD
NEW COLOURS sheet is that although the validation list picks up the new data
the VLOOKUP does not change to allow for the extra data the tha validation
list provided.

What I would like to know is there a way of including the range name into
the VLOOKUP so that I dont have this problem.

I tried the following without success:

=VLOOKUP(D15,COLOURS,4,))

I hope I have explained this ok

Thanks