| Home > Forum Home > Analyzing Corporate Financial Data > VLOOKUP with dates > Use the MONTH function | Share |
Use the MONTH function
Excel Help for Use The Month Function in Analyzing Corporate Financial Data
| Forum Topic | Login |
Use The Month Function | Rate this: (3/5 from 1 vote) |
 | When you do your VLOOKUP instead of using the date value to look up, wrap it in a =MONTH function so that it returns the number of the month that can be matched against the month number in your second table. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Use the MONTH function in the Excel Business Solutions Directory |