Hi
Cashelman
I have no access at the moment to my pc
So quite difficult to be as helpful as I would like
I personally tried with some data from Ayr and had no issues
The codes must be entered in the exact format they appear in DATA worksheet column BB
When you have entered these codes in STANDARDS worksheet column M and added the standards into column J , then you need to highlight columns J-M and tick your data has headings and sort column M (A-Z)
One other point I originally made this sheet for a friend who was only interested in AW, so in column AY on DATA worksheet I only made provision for 150 lines of standards in the lookup formula, this needs to be increased so anywhere in the formula 150 appears change it to 2000 and copy the formula down to match all the data you have, if you have more than 150 standard inputted this could also be reason for you errors.
Sorry about this if I had access to my office PC , I would have posted a new version.
Hope this helps , let me know.

I have no access at the moment to my pc
So quite difficult to be as helpful as I would like
I personally tried with some data from Ayr and had no issues
The codes must be entered in the exact format they appear in DATA worksheet column BB
When you have entered these codes in STANDARDS worksheet column M and added the standards into column J , then you need to highlight columns J-M and tick your data has headings and sort column M (A-Z)
One other point I originally made this sheet for a friend who was only interested in AW, so in column AY on DATA worksheet I only made provision for 150 lines of standards in the lookup formula, this needs to be increased so anywhere in the formula 150 appears change it to 2000 and copy the formula down to match all the data you have, if you have more than 150 standard inputted this could also be reason for you errors.
Sorry about this if I had access to my office PC , I would have posted a new version.
Hope this helps , let me know.
Last edited: