Sorry about that Myrna. The real data was lengthy, so I tried to edit it
down.

Regarding your answer, I was looking for a way to type in the name of a
month in one Cell (C1 in my example) and have the "answer" displayed in
another cell (D1 in my example). Is there anyway to substitute the word
"March" in your example with the Cell C1? That way the formula would 'look'
in Cell C1 and match it with the data in A1:B12. I tried various
combinations but none seem to work.

Thanks,

Steve





"Myrna Larson" wrote:

You will waste less of people's time if you post your actual data at the
start. :(

Since the data to be returned is to the left of the lookup column

=INDEX(A1:A12,MATCH("March",B1:B12,0))



On Mon, 15 Nov 2004 18:14:03 -0800, "SSHO_99"
wrote:

I see how all of the examples given in the two posts work, however I failed
to properly explain the formula I need. My example had 1=Jan, 2=Feb, etc.
However, the values I gave are not the values I will be using. Here is a
better example of what I need.

Assume this data is cells A1:B12

0.123 January
0.068 February
0.133 March
0.088 April
0.096 May
0.101 June
0.096 July
0.083 August
0.102 September
0.251 October
0.12 November
0.082 December

I want be able to type into cell C1 the name of a Month, and have the
corresponding value be returned in Cell D1, D6 and D10.

So, It looks like I need a Vlookup formula in Cells D1, D6 and D10 that
references the value found in Cell C1 and displays the corresponding value
found in the A1:B12 range of Cells. Hopefully this is a better explaination.

Thanks,

Steve


"SSHO_99" wrote:

I have 12 months and a value tied to each one. I was wondering what the
best
way is to place the value in a cell if another cell has one of the months.

I assume I could put an IF statement in each cell I want the results in.
For Instance, using the values below: IF A1="October",10, A1="November",11,
A1="December",12, (etc,) would place the appropriate value in the cell(s)
that have that IF statement.

1 = January
2 = February
3 = March
4 = April
5 = May
6 = June
7 = July
8 = August
9 = September
10 = October
11 = November
12 = December

Should I use a long IF statement that lists each of the 12 months (assuming
an IF statement can do that), or try a Vlookup function (which I'm not that
familiar with?)

Thanks,

Steve