#EXCEL IF THEN FORMULA PROGRESSIVE HOW TO#

I used the following formula for cells on my printout sheet (Image 1) cells A4-A5, the formula references the information in my data sheet, (Image 2): On my desired “quick reference print out sheet,” I used multiple “IF” functions to reference the row with the “1”’ in it, and it would populate the inspection. I have the data input sheet, I also have a nearly identical sheet with one row beneath the dates that looks at dates and puts a “1” directly below the corresponding date if it is within 10 days from TODAY. I have, 40 possible inspections per vehicle, but I know that no more than 15 will come due for the same vehicle at the same time. I want the sheet to list only the inspections that are due in the next, say 10 days. The issue is this, there won’t be enough space to have individual cells dedicated to all my possible inspections on my reference print out.

#EXCEL IF THEN FORMULA PROGRESSIVE HOW TO#

I figured out how to make excel show me what is coming due within the next XX days. I’m trying to create a quick reference sheet that automatically shows the upcoming inspections. I manually input the dates for the inspections. I have a Data Input page where I have my vehicles in the rows and inspections & date of inspection in the columns. I’m attempting to create a spreadsheet for maintenance at work, but having problems getting what I’m looking for.

Excel if then formula progressive