Whoo boy... I probably don't need to say I am an Excel novice! :)

I can pick my way through the program with general ease, but this new
idea I conjured up seems beyond my skill level. Moreover, I don't
know enough of the phraseology to find aid in my help searches.

Please bear with me, and I will set up the issue:

I have a multiple-sheet document started. The sheets share some data
between them and transpose it all onto one "master" sheet, as I call
it.

There are also MULTIPLE "data" sheets (about 20), each containing a
table - These sheets are important!
Each of these tables references a specific variable along the x and y.

I need a specific number transposed onto the MASTER sheet that was
taken from one (1) of the DATA sheets (a different sheet almost every
time, may I add) and I can't figure out how to fetch the specific x/y
co-ordinate of the answer.

Perhaps I need to provide more details? Yes, I believe I do. I can
imagine your glazed stare already. ;)

Data provided by the user for this aviation-related problem:
- Temperature
- Altitude
- Flap Setting
- Aircraft Weight

DATA sheets are broken down as follows:
- Each sheet is for a specific Flap Setting AND Altitude
- Table is set up with Weight up the vertical (y) axis, versus
Temperature along the horizontal (x) axis.
- The plot of x&y will give the user a specific speed for takeoff. <-
THIS IS THE # I NEED ON THE MASTER!

I need a formula (or method) to take the data provided, refer it to
the CORRECT data sheet (flap setting & altitude) as well as find the
correct x/y (speed) cell given the variables.

As it stands right now, I created a drop-down list that encompasses
the appropriate temperature, altitude, flap setting, and weight
ranges... But for the life of me, I cannot figure out how to use this
to grab the information from the charts on the data sheets.

I wish I could be clearer... But if you think you can help and would
like more details, please feel free to email and I will send a
snippet.

Thank you so much,
Craig

Suggest you start with the VLookup function which will find a value
in a table column and return the value from another column.
It is explained in Excel help.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"TheMilkGuy"

wrote in message
Whoo boy... I probably don't need to say I am an Excel novice! :)

I can pick my way through the program with general ease, but this new
idea I conjured up seems beyond my skill level. Moreover, I don't
know enough of the phraseology to find aid in my help searches.
Please bear with me, and I will set up the issue:
I have a multiple-sheet document started. The sheets share some data
between them and transpose it all onto one "master" sheet, as I call
it.
There are also MULTIPLE "data" sheets (about 20), each containing a
table - These sheets are important!
Each of these tables references a specific variable along the x and y.
I need a specific number transposed onto the MASTER sheet that was
taken from one (1) of the DATA sheets (a different sheet almost every
time, may I add) and I can't figure out how to fetch the specific x/y
co-ordinate of the answer.
Perhaps I need to provide more details? Yes, I believe I do. I can
imagine your glazed stare already. ;)

Data provided by the user for this aviation-related problem:
- Temperature
- Altitude
- Flap Setting
- Aircraft Weight

DATA sheets are broken down as follows:
- Each sheet is for a specific Flap Setting AND Altitude
- Table is set up with Weight up the vertical (y) axis, versus
Temperature along the horizontal (x) axis.
- The plot of x&y will give the user a specific speed for takeoff. <-
THIS IS THE # I NEED ON THE MASTER!
I need a formula (or method) to take the data provided, refer it to
the CORRECT data sheet (flap setting & altitude) as well as find the
correct x/y (speed) cell given the variables.
As it stands right now, I created a drop-down list that encompasses
the appropriate temperature, altitude, flap setting, and weight
ranges... But for the life of me, I cannot figure out how to use this
to grab the information from the charts on the data sheets.
I wish I could be clearer... But if you think you can help and would
like more details, please feel free to email and I will send a
snippet.
Thank you so much,
Craig

Thanks Jim, vlookup works just fine!

My next issue is the if/then series of input variables... I have read
about IF, but there doesn't seem to be a THEN command.

If I have a drop-down box in cell A2 that has 3 variables, can an
formula be set up that will determine which data sheet will be used
based on the number selected in that A2 drop-down box?

IE: if A2=500, then use the "500" chart on Sheet3

Thanks!
Craig

On Aug 15, 6:58 am, "Jim Cone" wrote:
Suggest you start with the VLookup function which will find a value
in a table column and return the value from another column.
It is explained in Excel help.
--
Jim Cone
San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"TheMilkGuy"

wrote in message
Whoo boy... I probably don't need to say I am an Excel novice! :)

I can pick my way through the program with general ease, but this new
idea I conjured up seems beyond my skill level. Moreover, I don't
know enough of the phraseology to find aid in my help searches.
Please bear with me, and I will set up the issue:
I have a multiple-sheet document started. The sheets share some data
between them and transpose it all onto one "master" sheet, as I call
it.
There are also MULTIPLE "data" sheets (about 20), each containing a
table - These sheets are important!
Each of these tables references a specific variable along the x and y.
I need a specific number transposed onto the MASTER sheet that was
taken from one (1) of the DATA sheets (a different sheet almost every
time, may I add) and I can't figure out how to fetch the specific x/y
co-ordinate of the answer.
Perhaps I need to provide more details? Yes, I believe I do. I can
imagine your glazed stare already. ;)

Data provided by the user for this aviation-related problem:
- Temperature
- Altitude
- Flap Setting
- Aircraft Weight

DATA sheets are broken down as follows:
- Each sheet is for a specific Flap Setting AND Altitude
- Table is set up with Weight up the vertical (y) axis, versus
Temperature along the horizontal (x) axis.
- The plot of x&y will give the user a specific speed for takeoff. <-
THIS IS THE # I NEED ON THE MASTER!
I need a formula (or method) to take the data provided, refer it to
the CORRECT data sheet (flap setting & altitude) as well as find the
correct x/y (speed) cell given the variables.
As it stands right now, I created a drop-down list that encompasses
the appropriate temperature, altitude, flap setting, and weight
ranges... But for the life of me, I cannot figure out how to use this
to grab the information from the charts on the data sheets.
I wish I could be clearer... But if you think you can help and would
like more details, please feel free to email and I will send a
snippet.
Thank you so much,
Craig

The term "Then" is used only in VBA code.
In a worksheet formula, "Then" is implied...

If("The cat is black", "Avoid It", "Feed It")...
-or-
If(True, do if true, do if false)

There are two separate help files, one for vba programming and
one for Excel. Look in the Excel Help file under "If Function".
Also, helpful advice here...
http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"TheMilkGuy"
wrote in message
Thanks Jim, vlookup works just fine!
My next issue is the if/then series of input variables... I have read
about IF, but there doesn't seem to be a THEN command.
If I have a drop-down box in cell A2 that has 3 variables, can an
formula be set up that will determine which data sheet will be used
based on the number selected in that A2 drop-down box?
IE: if A2=500, then use the "500" chart on Sheet3
Thanks!
Craig


On Aug 15, 6:58 am, "Jim Cone"
wrote:
Suggest you start with the VLookup function which will find a value
in a table column and return the value from another column.
It is explained in Excel help.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)