I’ve been using Excel for 10 years but this small task is trumping me.
Situation:
Sheet1 contains a table called “LessonsCompleted”. I need to validate all entries in the column titled “Student” so that they have an exact, case-sensitive match to a lookup list.
The lookup list is on Sheet2 and is in a table called “StudentsMasterList” and stable column called “Name”.
I learned how tot do this with arrays (Ex. $A$2:$A$10) but cannot figure out how to do it while referring to data in a table. What data validation custom formula would you use?
Attached is the sample spreadsheet if you'd prefer to use that.
Thank you!
Sample Workbook.xlsx
Bookmarks