VLOOKUP formulas will pull the data to appropriate cells.
See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.
http://www.contextures.on.ca/xlFunctions02.html
http://www.contextures.on.ca/xlDataVal01.html
Note the section on using DV lists from another worksheet by naming the list.
Gord Dibben MS Excel MVP
On Tue, 09 Oct 2007 09:21:22 -0700, "
wrote:
Help! I am going round in circles trying to resolve this, I have a
workbook with two sheets in it the following sheet detailed as below
and named Prices
Code Type Size Price
A011001 8 tier super 600mm £10.00
A011002 8 tier super special 600mm £15.00
A011004 8 tier mega 600mm £20.00
A011005 9 tier super 600mm £10.00
A011006 9 tier super special 600mm £10.00
A011053 9 tier mega 600mm £10.00
And in the same workbook I have a sheet called Order Sheet, in the
order sheet I would like to pick the items up in the Prices worksheet
but I cannot work out the formula for Validation (if thats the right
way)
So for instance, I want to select in my Order Sheet either the Code or
the Type and then excel fills in the rest ie Size and Price associated
so if I selected 8 tier mega my Order Sheet would look like
A011004 8 tier mega 600mm £20.00
Can anyone help