I have a list two list:

One that has the checks numbers I need

The second one has all of the checks written for the year and corresponding data.

I need an excel formula that will filter the second list by the first list and return only the checks and corresponding data that our on the first list.

---

Richard Chimes In...

You can use the MATCH function to determine if an item from list1 is in list2.

Let's say you've got a list of names in column A:

joe
bill
pete
sam

You've got a second list of names in column B:

pete
adam
sam

Now you want to figure out which people from column B are also in column A. Put this formula in cell C1 and AutoFill it down:

=MATCH(B1,A:A,0)

This says figure out if the value in B1 matches any value in column A. In this particular case, you'll get these values in column C:

3
#N/A
4
#N/A

The #N/A value means that the value did not exist. You can clean this up a little bit with the ISNA() function or an IF() function for custom responses, but that's basically how you do it.