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

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

i think i did that exactly as written and all I get is a false. I sent
you a file that I cannot, unfortunately, post to the NGs for all to
look at. If there is anyway you could help I would greatly appreciate
it
Dave Peterson wrote:
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

I had a typo. Try these:

=if(a1="","",vlookup(a1,sheet2!a:c,2,false))
and
=if(a1="","",vlookup(a1,sheet2!a:c,3,false))


Ratedr wrote:

i think i did that exactly as written and all I get is a false. I sent
you a file that I cannot, unfortunately, post to the NGs for all to
look at. If there is anyway you could help I would greatly appreciate
it
Dave Peterson wrote:
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

--

Dave Peterson