Hi there, I'm new to the site and my first post will be about an error I'm having.
I've got a really simple table that has the grades of a student in 5 lessons, and the name of that lesson. I want to find the lowest, highest and average grade of the student, and display them else where.
When preforming a max and average function on the range of values, and then VLOOKUP'ing that value from the table to get the lesson name string, it works fine. Although when I do the same with the Min function, it returns an error on the VLOOKUP.. Now when I replace the MIN function with a value (I.e. for the images below, I place the value 35 where the MIN function would go, and it still won't look up 35 in the table correctly.
Please see the two images below to help you understand more clearly, or use the document attached below.
Attachment 279772
Attachment 279773
Any help or advice would be greatly appreciated.
Many thanks, Toby.
Bookmarks