You could use data|validation to create that dropdown.
http://www.contextures.com/xlDataVal01.html
Then use =vlookup() to return the other info:
http://www.contextures.com/xlFunctions02.html
(Both links are to Debra Dalgleish's site.)
With the style dropdown in A1 of sheet1,
put this in B1:
=if(a1="",vlookup(a1,sheet2!a:c,2,false))
and this in C1:
=if(a1="",vlookup(a1,sheet2!a:c,3,false))
(and the table on Sheet2 in columns A:C.)
Ratedr wrote:
I have an excel sheet that looks like the following
style weight1 weight2
x 1.5 2.5
y 1.7 2.9
z 2 3.1
and so on (except that my database has over 1000 styles with weights,
etc) What I want to do is build a simple database that when I search
for y, for example, it will return to me the weight 1 and weight 2
result. For example it would have a line that says... Style? ____
and I put in y and then it says weight1=x
weight2=y
OR, I could have a dropdown menu that has all of the styles in it and
when I select the style I wanted, it displays the weights 1 and 2....or
anything like that. Can anyone help me with starting that and also
maybe if you have a better idea of what to do, it would be appreciated
--
Dave Peterson