Forum Discussion
Excel If Function
mtarler I have attempted to save the file type as multiple different options and am being denied to insert it here. You have alleviated my stressed question. However, what I am trying to accomplish is to create an action plan. I would like to have a selectable drop down option and based off of that selection, it would guide you to filling out the following steps to fill out. These steps once followed would provide a price from the aggregated data inserted. I can accomplish this task, but it involves multiple spreadsheets of calculations. I am creating this spreadsheet for my sales team and want them to have limited access. I can lock spreadsheets and calculations, but I would like for my sales team to remain in one spreadsheet. I know this is feasible, however I am rusty in excel as it has been taken from my repertoire many years ago! I appreciate your assistants and guidance in any way.
Thanks
Guardian1991 I don't know exactly what you want but in the attached I created a sample where you have tables for 3 options and then data validation based on each choice. I used the FILTER() function so it requires the new Excel. Instead of 3 tables it could be done in 1 table and lots of other options depending on what you have/need.
If you can't attach a file you can give a link to shared book in OneDrive or SharePoint or a dropbox or even attach in a PM on the site here.