How do I change the output value of a drop down box?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 C1:D10
column C is where you made your drop down list from, column D is where your
rebar output would reside
Then
=VLOOKUP(A1,C1:D10,2,FALSE)
TRUE means Col.C is sorted or FALSE for unsortd (alpha-numerical order)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation drop down box too large 5
Drop Down Problems 2
How to edit the size of a drop-down list (using data validation)? 1
Expand the size of a drop-down box 1
Formula and Drop Down List 1
Changing the font size of a drop-down box content 1
Excel Drop Down Box 2
drop down box font size in 2007 1

Back
Top