table w/ drop down lists and multiple formulas

[tiffamyrosek]

I have a table with 5 columns and each row is a option A, option B, option C and so on. Each column is a different category with a drop down list of options to choose from. column 6 I want to auto populate an entry based on what is selected in each drop down list in the first 5 columns. I am not quite sure how to have MUTIPLE formulas (outside of my table) that reference the selections on columns 1-5 in the table. PLEASE HELP!!!!

 

[Smitty]

Welcome to the Board!

Do you have a reference table listing all of the possible combinations and the results you want returned? If you do, then you can use a helper column to concatenate the selections, then VLOOKUP off of that.

It'll help if you post a shot of what you've got now (see the HTML Maker link in my sig for how), and what you want as a result.