Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Validation Formula Help
In cell H1 I have a data validation (list) 12 Months January through
December. The list is in cells V1 through V12. In Cells W1 through W12 I have a value of 1 through 12 that coreesponds to the month. For example the number 1 is next to January. I would like cell I1 to return a numerical value based on the month selected in the data validation cell H1. What would my formula be in cell I1? Thanks in advance. Steve |
#2
|
|||
|
|||
Hi
The column W is abundant. The formula in I1 will be =MATCH(A1;V1:V12;0) Arvi Laanemets "Steve H." wrote in message ... In cell H1 I have a data validation (list) 12 Months January through December. The list is in cells V1 through V12. In Cells W1 through W12 I have a value of 1 through 12 that coreesponds to the month. For example the number 1 is next to January. I would like cell I1 to return a numerical value based on the month selected in the data validation cell H1. What would my formula be in cell I1? Thanks in advance. Steve |
#3
|
|||
|
|||
Thanks......you guys are the best.
Steve "Arvi Laanemets" wrote in message ... Hi The column W is abundant. The formula in I1 will be =MATCH(A1;V1:V12;0) Arvi Laanemets "Steve H." wrote in message ... In cell H1 I have a data validation (list) 12 Months January through December. The list is in cells V1 through V12. In Cells W1 through W12 I have a value of 1 through 12 that coreesponds to the month. For example the number 1 is next to January. I would like cell I1 to return a numerical value based on the month selected in the data validation cell H1. What would my formula be in cell I1? Thanks in advance. Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
formula to determine the first column containing any data | Excel Worksheet Functions | |||
data validation on sth else | Excel Worksheet Functions |