Thanks for the response! yeah, i figured out my problem was that the table was not in the correct order. Once i flipped the table, it worked fine.
Thanks!
I need to create a LOOKUP Excel function to find grades. I already used:
=LOOKUP(B5,{0,60,70,80,90,100},{"F","E","D","C","B","A"})
Which works fine. BUT It has to be done using a table array/vector as such
Bob 85 Grade??
Sara 92 Grade??
using the table:
A+ 95
A 90
B 80
C 70
I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.