I downloaded data from my bank in a csv file, saved it as a spreadsheet. I need to create a search / look up function so I can go through all that bank data and calculate my expenses at different places for different time frames.

The problem is that the data looks like this:



“WAL-MART #1234 01-01-01 NEW YORK NY 9876 DEBIT CARD PURCHASE-PIN”

Of course, I have multiple purchases at Walmart, and the description is a little different for each one.

How do I do a lookup function to capture all the Wal-mart purchases throughout a given timeframe?

Or is there a better way than the look up function?


Thanks.