Okay, I've loaded the program and it's running, but I'm amending the code you've provided to read:

=LInterp($E2,$A2:$A8,B2:B8)

So the range that's analyzed changes dynamically throughout the spreadsheet.