Ahahaha, never mind, I just needed to adjust the range, this works perfectly. New formula reads:
=LInterp($E2,$A$2:$A$700,B$2:B$700)
I forgot to adjust for my range being larger than the example. We all have Tuesdays like this I guess. Thanks so much for your help.
Bookmarks