| Home > Forum Home > Analyzing Corporate Financial Data > VLOOKUP with dates > same problem but to lookup month and year | Share |
Same problem but to lookup month and year
Excel Help for Same Problem But To Lookup Month And Year in Analyzing Corporate Financial Data
| Forum Topic | Login |
Same Problem But To Lookup Month And Year | Rate this: (3/5 from 1 vote) |
 | I have the same problem but I need to check if a list matches the Month and the year. I'm trying to have a cell on a separate sheet return a true or a false if the date falls within the month. ie. List of dates that tool change is required 10-Mar-09 06-May-09 22-Jan-10 12-Feb-10 on a separate sheet i'm trying to search the dates above to see if there is a tool change required during the month Jan-09 Feb-09 Mar-09 Apr-09 FALSE FALSE TRUE FALSE I can calculate all the machines that have a true vales and the amount of tools on each that need to be changes for that month. | |
| James | ||
| Posted by jt-thorburn on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for same problem but to lookup month and year in the Excel Business Solutions Directory |