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...
LisaPriest In J3, try this:
=SUMIFS($D$3:$D$100,$A$3:$A$100,H3,$C$3:$C$100,I3)Change the sum range (in column D) and the criteria ranges (columns A and C) to ones that correspond with your real schedule. Have attached a mock-up based on the screenshot.