software

I want to create a drop down box that displays a rebar size. upon selection
of the size, in the output cell designated, I would like it to display the
area of that rebar size. I can't use a simple if statement because there are
10 different size and you can only use 7 nested if statement. what can I do?
If your drop down is A1
and you want your output to be in say B1
Lets say your list is in C110
column C is where you made your drop down list from, column D is where your
rebar output would reside
Then
=VLOOKUP(A1,C110,2,FALSE)
TRUE means Col.C is sorted or FALSE for unsortd (alpha-numerical order)

quot;DALLINquot; wrote:

gt; I want to create a drop down box that displays a rebar size. upon selection
gt; of the size, in the output cell designated, I would like it to display the
gt; area of that rebar size. I can't use a simple if statement because there are
gt; 10 different size and you can only use 7 nested if statement. what can I do?
gt;
gt;