title: How do I search for a string of numbers with Excel vlookup, only return the ones in the desired range, then sort the results?
body: <p>This is for a budget. I have the day of the month in one column (1, 2, 3, etc.) and the payment amount of the bill in the right hand adjacent column. I have a variable set of budget dates listed in two separate cells. I want to have a formula that takes all the days between the budget dates (would be nice if it also included the beginning and ending budget dates) searches the list of bills and returns the payments of those between the dates. For example, budget beginning date is 1, budget ending date is 13. There's a list of bills with random dates (1, 3, 4, 14, 18, 23, etc.). The formula would search the list of bills for any bill with the date 1-13 and return the payment for any matches (ex. it would return the payment for 1, 3, and 4 in the example but skip the rest). All matches would be listed in date order in separate cells. Then, if the beginning and ending dates were changed the formula would adjust without any additional input. See attached image.<a href="https://i.stack.imgur.com/1SedP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1SedP.png" alt="enter image description here" /></a></p>