=IFERROR(VLOOKUP(@$H$3:$H$693, 'Pay (2)'!$D$2:$P$398,10,0),"")
=IFERROR(VLOOKUP(@$H$3:$H$693, 'Pay (2)'!$D$2:$P$398,10,0),"")+IFERROR(VLOOKUP(@$H$3:$H$693, 'Pay (2)'!$D$2:$P$398,8,0),"")
I also tried this but cant get it to go +(VLOOKUP(@$H$3:$H$693, 'Pay (2)'!$D$2:$P$398,8,0),"")
=IFERROR(VLOOKUP(@$H$3:$H$693, 'Pay (2)'!$D$2:$P$398,10,0),"")+IFERROR(VLOOKUP(@$H$3:$H$693, 'Pay (2)'!$D$2:$P$398,8,0),"")
I also tried this but cant get it to go +(VLOOKUP(@$H$3:$H$693, 'Pay (2)'!$D$2:$P$398,8,0),"")