Forum Discussion
Union with conditions
Hi all, I am trying to merge 2 tables but am having trouble getting the outcome I want. I currently have a table showing students Attainment grades, based on subjects, and the report cycles that ...
Yeah I put it in as a new table. It seems to be the LOOKUPVALUE() function that it is having trouble with. It works fine if I leave that out, but that it obviously the key part that I need.
AlexisOlson
Super User
Super UserIn that case, you likely have more than one value for some grade in your table for a particular student and Subject combination, so it can't determine a unique value to return with the lookup.