# Need help: VLookup/Index: Tricky Bilinear interpolation

1. ## 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)

2. ## 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.

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

#### 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