Display result based on Drop Down box list choice

Hi there. I have two worksheets within a doc. I'm drawing a list of dropdown sizes from the master sheet "LUMBER". And based on the item chosen in the drop down, i want the cell beside it (Cell K) to automatically populate the value that corresponds to the size, as shown on the chart in worksheet "LUMBER".

Attachment 425086


Currently I'm doing this with a nested IF formula. But, I'm going to soon have over 50 sizes with corresponding values in the chart, so I don't think a nested IF forumula is the best way to do this. Is there a better way? Thank you!

The formula in cell K of sheet "PALLET" is: =IF(J3=LUMBER!$A$2,LUMBER!$B$2,IF(J3=LUMBER!$A$3,LUMBER!$B$3,IF(J3=LUMBER!$A$6,LUMBER!$B$6,
IF(J3=LUMBER!$A$7,LUMBER!$B$7,IF(J3=LUMBER!$A$8,LUMBER!$B$8,IF(J3=LUMBER!$A$9,LUMBER!$B$9,
IF(J3=LUMBER!$A$4,LUMBER!$B$4,IF(J3=LUMBER!$A$5,LUMBER!$B$5,IF(J3=LUMBER!$A$10,LUMBER!$B$10,
IF(J3=LUMBER!$A$11,LUMBER!$B$11,IF(J3=LUMBER!$A$12,LUMBER!$B$12,IF(J3=LUMBER!$A$13,LUMBER!$B$13,
IF(J3=LUMBER!$A$14,LUMBER!$B$14,IF(J3=LUMBER!$A$15,LUMBER!$B$15,0))))))))))))))



Note: I originally posted this thread under the following title "Function or formula for this"
http://www.excelforum.com/excel-form...-for-this.html

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )


Also, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

You want to use VLOOKUP
=VLOOKUP(reference, Array to look at, column to return, False (meaning exact matches only)

First I selected your lumber table Lumber!A2:B15 and made it a defined name (Formula Tab>Define Name) called lumber

Then in K3 for example

=VLOOKUP(J3, lumber, 2, FALSE)

To make it return 0 when there is no entry or match

=IFERROR(VLOOKUP(J3, lumber, 2, FALSE), 0)