Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2010 - Accessing data based on conditions from other sheets

15 Dec 2010   #1
DarkSnake

Windows 7 Professional x64
 
 
Excel 2010 - Accessing data based on conditions from other sheets

I've tried goggling this a bit and can't seem to find exactly what I'm looking for.

I'm trying to setup a sheet that can run calculations based upon what someone else enters (ex: if they select 'option1', preferably from a drop down list, then two values will be set to the corresponding values, ex: '5' and '6' or whatever they may be). This would preferably actually be within a formula, so say if they have selected an option, it will perform the calculation with the appropriate data, without having to display it on the current sheet.

I was also trying to keep all the data on another sheet so the one I was actually using looked a bit more organized. I've never had to do anything like this in excel before and was looking for some help or a push in the right direction.


My System SpecsSystem Spec
.

16 Dec 2010   #2
Irene

Windows 7 Home Premium 64bit
 
 

I have found the 'CHOOSE' function very useful.
Very difficult to explain, but here is Microsoft Office attempt... CHOOSE function - Excel - Microsoft Office

My scenario was to have a cell in which you would select Quarter 1, 2, 3 or 4. The values in the Profit & Loss Account would change accordingly. Here are examples of my scenario (the cells highlighted in the spreadsheet on the right refer to another sheet - CY Actual - in the workbook).

I hope this helps.


Attached Thumbnails
-choose-2.jpg  
Attached Images
 
My System SpecsSystem Spec
16 Dec 2010   #3
Adrian

 

Quote   Quote: Originally Posted by DarkSnake View Post
I've tried goggling this a bit and can't seem to find exactly what I'm looking for.

I'm trying to setup a sheet that can run calculations based upon what someone else enters (ex: if they select 'option1', preferably from a drop down list, then two values will be set to the corresponding values, ex: '5' and '6' or whatever they may be). This would preferably actually be within a formula, so say if they have selected an option, it will perform the calculation with the appropriate data, without having to display it on the current sheet.

I was also trying to keep all the data on another sheet so the one I was actually using looked a bit more organized. I've never had to do anything like this in excel before and was looking for some help or a push in the right direction.
Depending on the level of experience creating a pivot table for data selection would be an easy option.
My System SpecsSystem Spec
.


Reply

 Excel 2010 - Accessing data based on conditions from other sheets




Thread Tools





Similar help and support threads
Thread Forum
Excel Spread Sheets and Printing
Hi:The font in my Excel Spread Sheet will not print larger. It will display larger type but won't print larger. Thanks, Ardath Morrison
General Discussion
what are the options to recover deleted sheets within an excel file? n
what are the options to recover deleted sheets within an excel file? nothing in the recycle bin excel file isnt in \AppData\Roaming\Microsoft\Excel autosave is set to 120 mins though it should have saved at least once...
Microsoft Office
How to open two Excel sheets in their own window
I know before we upgraded, I could open two separate excel files in their own windows, so I can compare, etc without switching back and forth. I have the newest MSO and running Windows 7 Home Premium. Thanks so much in advance! b(^_^)d
Microsoft Office
Excel 2010 Script error popup when getting data from Web
Hi there I sometimes get a script error when getting data from web when using Excel 2010. This seems to depend on the ISP I'm using as I can take the laptop into some Wifi enabled Cafe's and EXCEL gets the data without the error popup. Since I like to run some of these as background...
Microsoft Office
Excel Sheets Disapeared on one specific file.
Hello, i have Office 2010 installed in my company. a user edited an Excel workbook and somehow got the sheets to disappear. if i open a new workbook, they appear fine. i know the trick about maximizing, but it's not the case. i also tried the Home>format>visibility>hide/unhide i managed to...
Microsoft Office
Data Visualization Features in Excel 2010
More...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 18:45.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App