Return records that meet certain criteria

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.

Maybe this is something that should be done in VBA.