Macro formula to match two columns and Produce result in fourth column.

thats because you had double entries for "chips", which cavlue would you want matched? the others all match because there is only 1 instance of the "item"

see the attached...