Formula Help #value

[zone709]

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),"")

 

[Fluff]

How about like

=IFERROR(VLOOKUP(@$H$3:$H$693, 'Paychex (2)'!$D$2:$P$600,10,0)+VLOOKUP(@$H$3:$H$693, 'Paychex (2)'!$D$2:$AC$600,24,0),"")

 

[zone709]

Works great thanks for the help

 

[Fluff]

You're welcome & thanks for the feedback.