Can someone tell me what I am doing wrong? VLOOKUP is not working correctly. I'm trying to lookup student name and paste a URL for each student. It works on some but not all. What am I doing wrong??? Thanks for your help!
Can someone tell me what I am doing wrong? VLOOKUP is not working correctly. I'm trying to lookup student name and paste a URL for each student. It works on some but not all. What am I doing wrong??? Thanks for your help!
Last edited by trfountain22; 04-05-2021 at 01:07 PM.
Where is the VLOOKUP that isn't working???
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
In I2 copied down:
=VLOOKUP(A2&"*",'Enrolled Student Listing'!$A$2:$E$1195,5,FALSE)
Some of the names are NOT exact matches (e.g. Daniel Gaines is NOT the same as Daniel Gaines Jr.).
By the way, I presume this is all dummy, desensitised data and not real people and their details???
Well, I guess it was sensitive data, as you have removed the workbook.
Thanks for marking the thread as solved, but a 'thank you' would have been courteous. You may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks