I have a table with horizontal and vertical values. I need to linearly interpolate horizontally to find the table value to the left and to the right of the value calculated. I've tried using hlookup but I keep getting the value to the left of the calculated value. I need to get the value to the right of the calculated value but I can't seem to figure out how to tell Excel to do that.
Bookmarks