+ Reply to Thread
Results 1 to 2 of 2

Need help: VLookup/Index: Tricky Bilinear interpolation

  1. #1
    Registered User
    Join Date
    02-28-2015
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    12

    Need help: VLookup/Index: Tricky Bilinear interpolation

    i have a table

    X Values 6 7 8 9 10 11 12
    7 3.06 3.11 3.19 3.30 3.46 3.66 3.86
    8 4.51 4.57 4.69 4.85 5.09 5.38 5.67
    9 6.32 6.41 6.57 6.79 7.13 7.53 7.93
    10 8.55 8.66 8.88 9.17 9.62 10.16 10.69
    11 11.20 11.35 11.63 12.01 12.58 13.27 13.96
    12 14.16 14.39 14.81 15.37 16.14 17.06 17.96
    13 17.69 18.03 18.68 19.50 20.47 21.47 22.60
    14 21.96 22.51 23.47 24.69 26.01 27.26 28.87
    15 27.19 28.11 29.60 31.44 33.42 35.30 37.93

    Suppose i want to find value of (8.5,13.2). I can easily write function =BiLInterp(8.5,13.2,D9:N18). (Bilinterp(X,Y,Table)

    The problem is X and Y values are to found out from two different table

    X table
    6.5 10.30%
    7.5 12.50%
    8.5 18.70%
    9.5 12.30%
    10.5 2.00%
    11.5 4.50%
    12.5 24.60%
    13.5 15.100%

    And Y Table
    7.5 0.00%
    8.5 0.00%
    9.5 0.00%
    10.5 0.00%
    11.5 47.90%
    12.5 51.88%
    13.5 0.22%
    14.5 0.00%
    15.5 0.00%

    Now I have to write the total sum such that: Sum over all X one by one: ((Bilinterp(X_Values,Each_Y_Value_one_by_One)* Coefficient of Y corresponding to each Y)* Coefficient of X)

    Please Please help.. I am struggling for last few hours. Thanks
    Last edited by rajsh; 03-04-2015 at 03:59 AM.

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Need help: VLookup/Index: Tricky Bilinear interpolation

    An example workbook detailing how your data is setup would be more helpful in visualizing your problem.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Bilinear Interpolation- help needed
    By rajsh in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-28-2015, 05:29 AM
  2. Tricky INDEX/MATCH Function
    By jj554 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-10-2013, 08:42 PM
  3. Bilinear interpolation of scattered data points
    By Sebi in forum Excel General
    Replies: 15
    Last Post: 09-19-2012, 01:05 AM
  4. Bilinear interpolation of irregular grid
    By Sebi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-15-2012, 05:19 PM
  5. Tricky index and match
    By robbo46 in forum Excel General
    Replies: 1
    Last Post: 06-21-2011, 04:18 PM

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