Forum Discussion
Match data in 2 columns and give value from 3rd column
Hello, I have a pricing spreadsheet from our supplier, which gives their part numbers in column A. But many parts are available in different colours, so they have used a "Colour Code" entry in colum...
=SUMPRODUCT(($A$3:$A$8=H3)*($B$3:$B$8=I3)*($C$3:$C$8=J3)*$D$3:$D$8)An alternative could be above formula.