I don't know if this is possible but here is my table:

Item Date Qty
xyz 7/3 452
xyz 7/4 225
zzy 7/2 120
abc 7/1 352

Can I do a lookup that will first search for Item, then date and return qty?
So if Item = xyz, and date = 7/4, then 452, else 0?

Any help is appreciated! TIA