This formula works below, but if there is no matching number in column D it returns #value. If the lookup numbers find each others numbers it returns what i need.
Would like it to return blank instead of #value if the look up numbers find nothing.
=IFERROR(VLOOKUP(@$H$3:$H$693, 'Paychex (2)'!$D$2:$P$600,10,0),"")+IFERROR(VLOOKUP(@$H$3:$H$693, 'Paychex (2)'!$D$2:$AC$600,24,0),"")
Would like it to return blank instead of #value if the look up numbers find nothing.
=IFERROR(VLOOKUP(@$H$3:$H$693, 'Paychex (2)'!$D$2:$P$600,10,0),"")+IFERROR(VLOOKUP(@$H$3:$H$693, 'Paychex (2)'!$D$2:$AC$600,24,0),"")