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!!!!