In addition to Max's post which gives you the easy solution, you need to
know that VLOOKUP doesn't have to have a list of sorted data as you suggest.
If you use the 4th argument with VLOOKUP either FALSE or 0, then it will
work with unsorted lists.
=VLOOKUP(your_value,your_table,2,FALSE)

--
Regards

Roger Govier


"Shakespeare"
wrote in message
...

similarly to the first post I was trying to nest more than 7 statements,
which isn't working.

I have a column of dates, and I'm trying to calculate the date using
the Month function. However that function only returns a number and I
want to display the month written out.

Here's the way I was going:

=IF((MONTH(A3))=7,"July",IF((MONTH(A4))=8,"August" ,IF((MONTH(A19))=9,"September",IF((MONTH(A23))=10, "October",IF((MONTH(A21))=11,"November",IF((MONTH( A26))=12,"December",IF((MONTH(A11))=1,"January","
No Month")))))))

I was going to try the vlookup function, however this spreadsheet is
setup as a "list" and vlookup says the table must be sorted in
ascending order... which might not be the case.

There has got to be an easier way to do this.

Thank you

J


--
Shakespeare
------------------------------------------------------------------------
Shakespeare's Profile:
http://www.excelforum.com/member.php...o&userid=21552
View this thread: http://www.excelforum.com/showthread...hreadid=392766