I am trying to create a VLOOKUP function to display a letter grade corresponding to a student's GPA. I entered the lookup value as the GPA, the array as the data table with letter grades and their corresponding values, and the column index as 1 as that is where the letter grades are located in the array. I keep getting N/A errors when I execute the function. I am following a video tutorial exactly, and where the tutorial gets a letter grade, I just get an error. Here are screenshots with my function. The lookup is on worksheet 1 and the array is on sheet 2 (lookup).
http://i.imgur.com/RGdNn.jpg
http://i.imgur.com/Ox4MU.jpg
http://i.imgur.com/RGdNn.jpg
http://i.imgur.com/Ox4MU.jpg