grouping

[Kyle Smith]

I have two columns and three rows with data I want linked / grouped. I have
put the first column of data into a drop box, aka you select one of the three
options. I want to link that selection to the corresponding data.

Example
54" $20
60" $30
66" $40

I want to have a drop box where you select the size (54") and then next cell
automatically puts the corresponding price. Thanks in advance

[JulieD]

Hi Kyle

select the cells with the sizes in them and then click in the little box to
the left of the formula bar above the letter A and type a name for this area
(a range name) e.g. SIZES and press ENTER (won't work if you don't press
enter)
now select both the sizes and the cost column and create another range name
(e.g. COSTS).

then click in the cell where you want the drop down box (i'm assuming D1 for
this example) (can be on another sheet) and choose data / validation
choose allow
list
click in the source box and press the F3 key
you'll get a list of the range names in your workbook - choose SIZES - ok

now in the cell adjacent to this cell type
=IF(D1="","",VLOOKUP(D1,COSTS,2,0))

now when you choose an item from the drop down list in D1, the associated
cost will be displayed in the adjacent cell.
(for more details on the above, and other fun stuff, check out
www.contextures.com/tiptech.html)

Hope this helps
Cheers
JulieD


"Kyle Smith" <Kyle [email protected]> wrote in message
news:[email protected]...
>I have two columns and three rows with data I want linked / grouped. I
>have
> put the first column of data into a drop box, aka you select one of the
> three
> options. I want to link that selection to the corresponding data.
>
> Example
> 54" $20
> 60" $30
> 66" $40
>
> I want to have a drop box where you select the size (54") and then next
> cell
> automatically puts the corresponding price. Thanks in advance