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

Hi there, I have 1 Excel spreadsheet with multiple worksheets within. In sheet 1, I have the following 4 column headings; First name, Surname, EmpID, Pay Rate. Each column has multiple rows of related data. In sheet 2, I have the same column headings but not the rows of data. In sheet 2, I would like to enter and equal sign under column 'First Name', then switch over to sheet 1, choose the relevant row of data, for that full row of data to be populated in sheet 2 under each of the column headings. Please advise if this is possible... and how! Many thanks in advance.

I have a column that is the status (Not Started, In Progress etc.) I want that to equate to my column of % Complete. So if I choose Not Started it automatically will make my % Complete row 0%, In Progress will be 25% etc...

when I do the conditional formatting on a dropdown, and I choose something from the drop down, the color change, which is correct, but when I select it again from the drop down, the color only change half the way

Which of the following procedures does not filter a table by the contents of a single column? a. Click on the criterion button on the segment. b. Right-click the cell whose content you want to choose as a criterion and click Filter on the menu. c. Click the Filter button in the Sort and Filter group on the Data tab. d. Click on the Automatic Filter button in the row of totals at the bottom.

How Can I include different state in one column. For example if the Header is Book Condition I have to choose only one from Good,poor and terrible.

1. What is the feature that helps you choose appropriate charts for data?

Hi, I am working on a financial table excel model where I have a 5 year picture. In some projects, the cost starts in year 1 and for others year 2 or year 3. I am looking to insert a table that will pick up costs automatically where all I do is choose which year the project begins in. Hope I am making sense.

Our office does a joint purchasing spreadsheet with a bunch of items we can order. They send it to us. We have to copy and paste what we want onto a sheet that calculates the cost. I dabble in excel but I know there has GOT to be an easier way. I need a push in the right direction that will Allow the office to send a list to us as to what we want. Have us choose the quantity and then send it back as spreadsheet that lists what we chose to order, how much and the cost. It can only list items we ordered-not the whole list. Also need the office to Take all the items from different ss and come up with a building total of what was ordered.

7. At Talent Tracs, all employees are eligible for the company’s health Plan. Employees can choose one of four health plans: an HMO for individuals (HMOI), an HMO for families (HMOF), a PPO for individuals (PPOI), or a PPO for families (PPOF). Each plans has a different cost, and Talent Tracs pays the entire health plan cost. If an employee shows evidence of coverage elsewhere, there is no health plan cost.

I have, say, 10 columns of data, and I want to be able to find all the values in between two dates and graph it by whatever column I choose. I have been searching online for a couple days but I keep coming up with #VALUE or #REF. I can get VLOOKUP to find the values, and I can get it to find a piece of data for the start time and the finish time.. but anything in between will not come up.. so I can't even graph it! I am trying to create a dynamic chart that will change if I type a datetime into a box for start and finish.