I have a two rows of cells where one row is the amount of a behavior (e.g. number of calories eaten) and the second row is points you get for that amount of the behavior. A shortened example is:
Calories 1000 1200 1400 1800
Points +100 +50 0 -35
I want to be able to lookup the Points for a given level of calories. I know I can use HLookup, but when I do that and enter a Calories value not in the table (e.g., 1100) I get the Points associated with the lower calorie value, i.e. 100 points rather than the value I want which is halfway between the two tabled values, i.e., +75.
Any ideas on how I can most easily get the correct values in between the tabled values?
Thanks,
Bob Pritchard
Bookmarks