New
#1
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.
Last edited by DarkSnake; 15 Dec 2010 at 14:20.