I'm trying to figure out if there's a formula I can use to auto-enter my GPA
on a spreadsheet I have for school.

I have a column with my current grade percent and a table that shows the
percent ranges with the corresponding GPA....(i.e. my grade column shows
96.00% and the table shows 90-100% equal to 4.0 89-85% equal to 3.5 etc)

Is there a way to have excel look at the 96.00% then reference the
percentage range in the table and auto-enter into another cell the
corresponding GPA?