I am familiar with the MATCH() and INDEX() functions. Banging my head against the wall on this one. Need to find value of Y given X and table of Z values. X is always on the top row and is not intermittent. The table is Z values. Say I have an X of 20 and a Z of 1000, Y should be interpolated value in between 2.2 and 2.4, see attached spreadsheet. Any help?
Table of Z Values:
X
10 20 30
Y 2 676 1190 1720
2.2 605 1070 1550
2.4 546 959 1400
2.6 496 872 1280
2.8 453 796 1170
3 415 730 1070
X 20
Z 1000
Y = ?
Bookmarks