Hi,
I'm having an issue with a spreadsheet im attempting to put together, I'm receiving N/A errors as its failing to look up the value from another sheet.
Basically, I have a 'Staff' sheet, with staff in my department and a second sheet of 'Results' with everyone's course results, exported from an online system. The trouble is, there is no way to filter out my specific department from the original list, so I've put together a list of my staff that I can then lookup in the original list.
Using other formulas, i've determined that the helper columns are displaying the same value and are also not duplicated. But still nothing is retrieved. I'm also aware that one of the courses, has an odd character in it, but this doesnt change if it were removed.
Attached is a sample of my sheet and also anonymised too.
Thanks in advance, Paul.
Bookmarks