Get instant live Excel expert help to learn how to use Choose function in Excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I am creating a marketing campaign plan template that automatically converts the plan into a to-do list and also gives tips. I am so far: I created table 1 the plan. The most important fields are here Form of Content G8-19 Inhouse/ outsource H8 - 19 and Channel I8-19. In this fields you can choose sth via a Drop down menu. Everything works I created table 2 the action plan. Her is B2 = G8 and C2 = H8. So in table 3 I create under A The To-Do's if you choose a certain Form of Content if you outsource it or do it in-house. and also Tips if you outsource this task or do it in-house. Here is my problem I need somehow in table 2 to be displayed what I created in table 3 depending on what you choose in table 1. It's a bit hard to explain but I can share the document.
Solved by I. C. in 14 mins
I want to create a relationship between 2 cells, ie so when I choose an item on a list it automatically shows a specific room number next to it?
Solved by E. F. in 19 mins
I am entering sales figures for staff and have filters, when I choose a particular filter how do I create a sum to add up the figures
Solved by V. U. in 26 mins
Question 1: The AnalyzeSurveydata.xlsx file contains answers using a 1-7 scale to various questions on a teaching evaluation survey. Create a PivotChart that charts the fraction of the time each value 1-7 occurs for each question. Filter the chart to show the breakdown for any set of three questions you choose.
Solved by X. C. in 12 mins
Please help debug my if/else statement! =IF(E11="Please choose a shaft ",0,(IF(E11=F11),1,2))
Solved by I. J. in 26 mins
I want to be able to choose the all option in column A of the "MASTER" sheet and have whatever I enter into the rest of the cells for that row show up in every worksheet in this workbook not just one persons (so not just the CEO sheet or just the CFO sheet but alll of them). so basically I want an OR type statement to be dropped into the formula for all the sheets
Solved by X. J. in 11 mins
How do I modify the formula (All formulas in this workbook are the same really) to get the rows in every sheet (Obviously excluding the "MASTER" sheet since its the source data) to push up to the top. Ex. If in row 8 of the master sheet I choose column A to have a value of "CEO" the rest of the information in that row populates into the sheet named CEO but it goes into row 8 so all the other rows before it are blank.... I need the data to go to the first blank row.
Solved by G. Y. in 27 mins
I would like to choose from a dropdown list (any selection) and then have it populate several lines below (address). Will always populate the same address for any selection in the dropdown. When listing or selling agent is chosen from the dropdown on line 43 I want to populate lines 49,51,53,55,57 & 59 with address and telephone info How would I do this?
Solved by K. F. in 27 mins
I have been working with Pivot Tables for this data, but I feel that a macro may be better at this point. Essentially, I have exported an survey that has been attached to an event session. There are three questions for each session and each question has 5 answers to choose from. I would like each question to show a graph like this: Question: I feel confident that I can apply what I learned. Session Item: RED Count of each option: Definitely Yes!: 4 Definitely No: 2 Sure: 18 No: 0
Solved by O. J. in 14 mins
I want to apply IF(AND) to two Data Validation Lists - meaning, If I choose from list 1 option 1 and from list 2 option 2, I get a specific output.
Solved by Z. J. in 25 mins