Hello.
I have a grade tracking sheet but the lookup is not working properly.
There are two sets of grades, and then a column is needed to "track" the difference.
Column A - Current Grade (alpha)
Column B - Expected Grade (alpha)
Column C - "On Track" (numeric e.g Current C, Expected A on track would read -2)
Rows are allocated to a student each.
Grades - A*, A, B, C, D, E, F, U (Highest first)
I am happy for there to be a separate lookup elsewhere on the sheet.
Thank you in advance!!
Easily done - I do it all the time, as I am a teacher. I'll put something together and attach it here for you within the next ten minutes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Here you are. The lookup table could be anywhere and could, of course, be hidden.
Ahhhhh wonderful!!!!
That looks great.
What is substitute, I've never heard of that?!
Thank you so much!
:-)
Hi, Bryony!
What substitute does is look for the string "A*" in the referenced cell (if that cell contains it), and replaces it with "A~*". It does this before the VLOOOKUP is calculated. Without it, "A*" would be seen as "A" followed by a wildcard, so it would return the value of "A" instead of "A*" from the lookup table. The "~" (tilde) character tells Excel that this really is "A*" and not "A" + a wildcard. Hope this explains it!
Last edited by AliGW; 04-15-2014 at 06:05 AM.
OOPS! Duplicate post - sorry!
How clever!
Thank you!
Must have been where mine was going pear shaped!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks