Could you she the workbook
I wouldn't be able to show it due to confidential data!
Here you go.
if [Year]="2015" then [Score] end
if [Year]="2016" then [Score] end
lookup_rep_9.0.twbx 26.1 KB
dint understand it..
Could you attach your workbook as packaged (***.twbx)?