Excel help needed- VLOOKUP for table of months?

Question

Hey, I have used the =month function to order my data by month, from a list of dates, it gives me say '1' for january, '2' for feb, etc. Now I want to use the vlookup to change these numbers to the words they represent. I've made another sheet with a1-a12 being number (list of 1-12), and b1-b12 being the corresponding month (list of jan-dec).
How can I - using vlookup - modify the =month column to display the equivalent month that I've referenced in the other sheet?
Thanks!

Answer 1

That's a rather complicated way of doing it. An easier way would be to copy the range of month values that resulted from the function and paste them as values in the same column. Then use replace (ctrl-h) to find and replace each value. Hint: Start with 12 and work your way down to 1.



If you're set on using vlookup, you still have to convert the cells that have the month function into values. Highlight the whole column, right click, select copy, then right click, select paste special, select values, and click ok. In the next column to the right, type =vlookup( then click on the cell that has the month number, type a comma, then go to the spreadsheet with the month names and highlight the entire range of numbers and months, type a comma, type 2, type a comma, type false).



Example: assuming your month number in the first spreadsheet is in column E and the data starts in row 4 and assuming the month names are in a file called Month =vlookup(E4,[Month.xls]sheet1!$a$1:$b$12,2,false).

Answer 2

"a nested month"...yeah particular. How a pair of flibbertigibbet year, too? "=VLOOKUP(weekday) (A2), DayTable,2)" is rubbish. It would not artwork as you declare in case you're nonetheless lacking it: a "nested" month has no obtrusive which skill. You neither clarify what the information enter is, nor what the needed output is. evaluate self-progression.

Answer 3

There is a much much more easier solution



Instead of =month(A1), paste this

=TEXT( A1, "mmmm")



That is all



VBAXLMan

Answer 4

Go to http://www.mrexcel.com register for free and post your question there. Alternatively, just search the forum for answers