VLOOKUP and COUNTIF but kept getting errors

It sounds like your data being compared is inconsistent,
ie you could be trying to match text numbers with real numbers or vice versa

Try these variations:
=vlookup(A2&"", ... )
A2&"" will make the numeric product code into text nums, w/o impacting on its intrinsic value
This presumes your reference lookup data (ie the 1st col in the range) are text numbers

=vlookup(A2+0, ... )
A2+0 will make the text number product code into real nums, w/o impacting on its intrinsic value
This presumes your reference lookup data (ie the 1st col in the range) are real numbers
-------
Success? Celebrate it, hit the little star at the bottom left of my response

Hi Max - Thanks for looking at this, I will try it out and let you know how it goes. There are a few other comments too so I'll give them atry and should come up with a workable solution
Kiwiscotsman