I want to do a partial lookup on a cell and then return a text value I set. For example: I have a column of dates such as 1/1/13, 4/12/13, 6/1/13. I want to lookup the first number and then return the corresponding month. So 1/1/13 would return a value of January, 4/12/13 would return April, etc.
Thanks!
Hi -
You could use the MONTH function to return the number of the month (e.g., 1 for January, 2 for February, etc.). Then use VLOOKUP function to look at a list you have defined with 1 corresponding to the text January and so on.
Hope that helps.
okay, lets say your dates are in Column A starting Row 2, and you have the month names in say Column Z, starting in Row 2
This anywhere would return the Month for A2:
=INDEX($Z$2:$Z$13,MONTH(A2))
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Try this...
A1 = some date
This formula will return the long month name:
=TEXT(A1,"mmmm")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
The TEXT function works but if the cell is blank it's still returning January as a month value. It should contain nothing in the cell.
=IF(A1<>0, TEXT(A1,"mmmm") ,"")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Try this...
=IF(N(A1),TEXT(A1,"mmmm"),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks