What would be the basic approach to creating a monthly lookup table that
would allow the user to select the text value for the month and return the
numerical value to the cell.
Can this be done solely within excel or does it involve interaction with
something such as VB?

Thanks