VLOOKUP MONTH & YEAR formula
I need to update my formula so that it captures the month & year of a date.
Here is what I have now: =IFERROR(VLOOKUP(MONTH(D8)&"/"&YEAR(D8),Months,2),"")
So far the formula only returns the "NULL" value from my table.
Months_Table.jpg
•D8 represents the cell containing my date.
•"Months" represents my table containing the months of the year
Any help would be appreciated
Please post a sample sheet so we can work with it. Thank you
IFERROR(VLOOKUP(PROPER(TEXT(D8,"MMM/")&YEAR(D8),Months,2),"")
VLOOKUP_Test.xlsx
Here is a test sheet to play with.
Thank you very much for any advice you can offer.
I tried this formula and got an error message that I had entered too many arguments.Originally Posted by tim201110
Thank you for your response. I appreciate the effort.
Perhaps this...
=IFERROR(VLOOKUP(C4,Months[Column2],1,1),"")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
This worked perfectly!
Thank you!!
Happy to help. For future reference, if you post on another forum, you must include a link to that thread here (and there), so that members dont waste their time answering a thread that may already have been answered on another forum
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks