Vlookup for multiple criteria

[ritz]

Does anybody know if you can do a vlookup (to another sheet) that can identify multiple criteria? Here i'm trying to identify on another sheet specifically 1) the customer and then 2) type of transaction?

Thanks,

Ritz

[jasoncw]

Hi, Ritz. Based on your brief description, the SUMPRODUCT function may be more appropriate than VLOOKUP.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html