Drop down list that auto populates appropriate cell

Greetings!

I hope I can explain this with ease of following what I am trying to accomplish. I am in process of creating a costing sheet for the company I work for.

1. I have created a drop down list of specific materials and thicknesses
2. I have specific costs associated with the specific materials and thicknesses for the cut charge.
3. How do I associate a specific material and thickness to the appropriate cost for the cut charge to populate in the cell ("Cut Charge") that I want?

Your description is a bit vague in terms of where your data is located, so my answer can only be equally as general - you would tend to use VLOOKUP to return corresponding data from a table, where the item that you are looking for (i.e. that you have selected in your drop-down) appears in the left-hand column of the table. If it appears in a different column, then you would tend to use an INDEX/MATCH combination. Often you would use an IFERROR function around this, to avoid returning errors if the sought item is not in your table.

Hope this helps.

Pete

My apologies, I have the "Material" and "Cost" located on the second sheet of my workbook.

We still can't give you an actual formula, as we would need cell references in that formula, but rather than describe the use of every column here, it is easier for you to attach a sample workbook - the FAQ describes how to. You can include extra notes within that workbook which explains more clearly what you want to achieve.

Pete

Alright, here is the book that I am working on.

As you can see I have specific information already entered in.

Cells E11 thru E46 I have the drop down with my materials and thicknesses.

In cells F11 thru F46 I want the cost associated with the material and thickness (found on the "Material and Charge" sheet) populated in this column.

Then in cells C11 thru C46 I will manually enter in data from my drawing.

After I enter information in C11 thru C46 I want to use a simple formula to take my cut length times my cut charge and display that information in the "Total" column then finally calculate a grand total.

Put this formula in F11:

=IFERROR(VLOOKUP(E11,'MATERIAL AND CHARGE'!$A$2:$B$19,2,0),"")

then copy down.

Hope this helps.

Pete

Pete, that works! Thank you so very much!

I truly appreciate your help!

Glad to help - thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete