Auto Filling multiple Values, based on range.

I am working on a Spreadsheet to calculate GPA, I have all the formulas I need but right now I have to manually enter in the Point Grade, Letter Grade, and the Class Grade Point. I imported a new sheet that has the range of grade points and the resulting grade letter, and the grade average.

What i'm trying to do is after I input the decimal grade I want it to reference the other sheet to determine which range it falls into and then auto fill the letter grade and the grade point for the class in the appropriate values.

I know just enough about Excel to know that I am completely lost, I remember doing something similar on the Excel Expert 1 MOS exam using an Array? Anyone able to help?

@ scott Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

@ rcm Sorry for off-topic interjection:

Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

Thanks again for all your hard work here!