I'll try to explain my question as best as possible.
I have a spreadsheet of books sold at different discount levels. So colA = Discount level, colB = Title, ColC = Quantity sold.

The formula I'm trying to get is to return the quantity in ColC if ColA=.35 and ColB='examplebooktitle1'

I want the formula to scan a range of cells to match the criteria and when a match is found to return the value in ColC for that Row.

The report I receive is different month to month as different discounts are used each time, as well I'm using a MAC for this project and thus am not able to write this in VBA.

Thanks for any help,

Chris