Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel Function Help please!!!
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...- Kbillings
- Thread
- Replies: 3
- Forum: Microsoft: Office
