William

Assume you have two columns on Sheet2

A with fabrics to A40

Give A1:A40 a name through InsertNameDefine. I'll call it fablist

B with Cost for each to B40

Switch to Sheet1 and in A1 Add a DataValidationList drop down.

The source for this list is the list on Sheet2 and you enter it like this in
the DV source dialog.

=fablist

In B1 enter =VLOOKUP(A1,Sheet2!$A$1:$B$40,2,FALSE)

Select a fabric in A1 and cost will pop up in B1


Gord Dibben Excel MVP

On Fri, 23 Dec 2005 15:32:02 -0800, "Soccer Guy" <Soccer Guy
@discussions.microsoft.com wrote:

I'm trying to streamline how to determine costs to make a garment easily. We
have muliple different fabric options, each with its own cost.

How do I create a drop down box that lists the fabric names and also links
this selection to the cost of the fabric so I can easily see the differences
in cost when selecting a different fabric?

Any help would be greatly appreciated.

William