+ Reply to Thread
Results 1 to 3 of 3

Merge multiple tables in one table

  1. #1
    Forum Contributor
    Join Date
    07-08-2012
    Location
    beirut
    MS-Off Ver
    Excel 2010
    Posts
    102

    Merge multiple tables in one table

    Hi,
    I have several tables, each table is for a specific altitude, where torque is calculated based on a given temperature.
    I need help to find a way to create 1 table that uses all the calculation from the other tables, where torque is calculated based on given temperature and altitude.
    For example:
    for altitude 4000 and temperature 30, torque is 93.2.
    for altitude 6000 and temperature 25, torque is 90.5.
    What If I want the torque for altitude 5000 and temperature 20, is there any way?

    I provided a sample for better understanding.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Merge multiple tables in one table

    looks like your torque is a calculated figure based on those two variables, so just copy the torque formula to cell h3 and then type in your temp and alt and you will get 71.1 psi for alt 5000 temp 20 c, also you would have to have the headers be the same as your other tables where alt is in the f column and temp in your g column

  3. #3
    Forum Contributor
    Join Date
    07-08-2012
    Location
    beirut
    MS-Off Ver
    Excel 2010
    Posts
    102

    Re: Merge multiple tables in one table

    But the torque should change whenever I change the altitude. In your way, the torque will be calculated disregard the altitude.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1