VLOOKUP problem (N/A error)

[raulduke]

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

 

[DonkeyOte]

raulduke,

Welcome to the Board. If you opt to cross post the same question on different message boards please reference accordingly:

http://www.excelforum.com/excel-general/799992-vlookup-problem.html

 

[Michael M]

Hi and Welcome to the Board
I can't see the pictures very clearly, might be my access, but
Shouldn't your formula be:

=VLOOKUP(Exercise1!B13,D20:E24,1,FALSE)

You didn't reference the other sheet

 

[Michael M]

Thanks for the point out on the posting DonkeyOte

 

[raulduke]

Hi and Welcome to the Board
I can't see the pictures very clearly, might be my access, but
Shouldn't your formula be:

=VLOOKUP(Exercise1!B13,D20:E24,1,FALSE)

You didn't reference the other sheet

I tried that but it still gets an N/A error