I have list of records setup of in rows. I'm trying to get the list broken down some and get the records returned that meet certain criteria

column a invoice number as string
column b sales person name
column c ontime (true or false)
column d date
column e customer name
column f warehouse location

What i'm thinking is something like:

if customer name = "some string" & ontime = false & location = "Kansas City" then list the data in column a thru f

Any ideas? I could probably do a lookup and find the first record, but having excel go through an array and return all the records matchign the critera is beyond me.