lookup based on mult. criteria

  • Thread starter Thread starter matt
  • Start date Start date
M

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
 
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
 
Back
Top