How do I solve this problem if I need to pick up electives passed from table 1 to the highlighted (gray) cells G10 and I10? As there is no single choice of electives, the cell reference for lookup is not working. Rather, I need to check the whole list of electives on the right, check which electives the students studied, and only pick up the passed ones as attached.
Bookmarks