lookup based on mult. criteria

[matt]

i am trying to run a lookup that will pull all bank
transactions for a given account in a given state in a
given month. based on these criteria, i will need to pull
up all of the transaction details. thanks for the help.
matt

 

[ray]

Hi Matt
Chip Pearson has some information on the subject. Try this
site http://www.cpearson.com/excel/lookups.htm#DoubleLookup

 

[Don Guillett]

A lot more info would be helpful. If you just want a total use
=sumproduct(month(rngA)=2)*(rngB="TX")*rngC)

if it is a database use the autofilter or advanced auto filter
look under data>filter
or use a pivot table