IF to SELECT CASE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Instead of having this IF statement
=IF(A1=DATEVALUE("1/1/04"),"NEW YEAR'S",IF(A1=DATEVALUE("1/19/04"),"MLK DAY","")
I would rather have a SELECT CASE statement. How do I do that? In particular, how do I reference the date cell
Thanks
Howar
 
try
select case range("a1")

--
Don Guillett
SalesAid Software
(e-mail address removed)
Howard said:
Instead of having this IF statement:
=IF(A1=DATEVALUE("1/1/04"),"NEW YEAR'S",IF(A1=DATEVALUE("1/19/04"),"MLK DAY",""))
I would rather have a SELECT CASE statement. How do I do that? In
Click to expand...
particular, how do I reference the date cell?
 
Create a table of dates (say in column J) and names (in column K).
Then use

=VLOOKUP(A1, J:K, 2, FALSE)
 
Back
Top