| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula prob - or is it validation?
In cell A1 I have created a list with options - 1st quarter results, 2nd
quarter results, 3rd quarter results, 4th quarter results. Cells A2, A3 & A4 are for the months of the quarter. If I select "1st quarter in A1", I want A2 to read "Jan", A3 to read "Feb", & A4 to read "Mar". If I select 2nd quarter in A1, I want A2 to read "Apr", A3 to read "May" & A4 to read "Jun".....and so on thru the 3rd and 4th quarters. I have investigated IF statements, but they don't work... I'm so stuck. Is anyone able to help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CSE Formula Prob | Excel Worksheet Functions | |||
| vlookup prob with all #n/a's | Excel Discussion (Misc queries) | |||
| Macro Prob | Excel Worksheet Functions | |||
| Counting prob | Excel Discussion (Misc queries) | |||
| A little help, prob simple to anyone else | New Users to Excel | |||
Threaded Mode
