I'm using an on-going spreadsheet to track the number of patients me and my staff see each month. I want to make another tab and using vlookup pull information for the data tab over to the stats tab. I only want to pull the information over to the stats tab if the date in row S is in the month of April. Is there a formula to vlookup only if the data in the cell is within a certain month?
Bookmarks