SPREADSHEET AND PURPOSE
This spreadsheet is designed to list people, and the training groups (cohorts) they belong to.
One tab is a list of cohorts, including names, dates and training information.
The second tab lists individuals. Each individual is given a cohort name - which is actually a hard reference to the name in the other tab. (So all cohort names are dynamically derived from the cohort data directly).
My aim is to use VLOOKUP to assign an individuals training data based on the cohort they belong to (pulling from the other cohort info tab).
PROBLEM
The VLOOKUP works for almost every cohort, except those whose name begins with "22AprilEnable...". These rows are returning #N/A
I can't work out why. It should be able to find a value it is itself already returning from the lookup location (as it is with the other rows).
NOTE: if I change the name of the affected cohorts in the cohort tab, the #N/A is replaced by data from an entirely different row further down the lookup table.
This is driving me a bit crazy, I must say ... I might have missed something obvious.
Bookmarks