IF to SELECT CASE

H

Howard

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
 
D

Don Guillett

try
select case range("a1")

--
Don Guillett
SalesAid Software
[email protected]
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?
 
J

J.E. McGimpsey

Create a table of dates (say in column J) and names (in column K).
Then use

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