Easy dv Question

  • Thread starter Thread starter cmk18
  • Start date Start date
C

cmk18

I know there is a way to have a value associated with a selection using
data validation. Essentially I want someone to be able to choose
December, but have excel record 12. I don't want to use vlookup or
select case.

Thanks
 
How about another cell with this formula in it:

=IF(A1="","",MONTH(DATEVALUE(A1&" 1, 2005")))

Alternatively, you could use a Dropdown from the Forms toolbar and just use the
linked cell.
 
Back
Top