Need formula

[noelmus]

Hi,
I have cell C12 with a drop down list which are 1 & 2,3 & 4,5 & 6. I need that:
1. When I choose 1 & 2 from the drop down, cell E17 appears as METER 1 and cell H17 appears as METER 2.
2. When I choose 3 & 4 from the drop down, cell E17 appears as METER 3 and cell H17 appears as METER 4.
3. When I choose 5 & 6 from the drop down, cell E17 appears as METER 5 and cell H17 appears as METER 6.
Any help is appreciated.

 

[Joe4]

Try this formula in E17:

=IF(C12>0,"METER " & C12-IF(ISEVEN(C12),1,0),"")

and this formula in H17:

=IF(C12>0,"METER " & C12+IF(ISODD(C12),1,0),"")

 

[Fluff]

Try
="Meter "&LEFT(C12,1)
="Meter "&RIGHT(C12,1)

 

[jim may]

Does Cell C12 contain ONLY 1 of the following 3 values?:
1 & 2
3 & 4
5 & 6

 

[noelmus]

Hi,
Both of them gave me

#VALUE!

<tbody>
</tbody>

Thanks

 

[noelmus]

Hi Fluff
Bullseye

Thanks

 

[Fluff]

You're welcome & thanks for the feedback

 

[Joe4]

Sorry, I misunderstood your drop-down box. I thought it had the indivudual values 1-6.

 

[jim may]

Excel 2010

	C	D	E	F	G	H
10
11
12	1 & 2
13
14
15
16
17			METER 1			METER 2
18
19

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula E17 =IF($C$12="1 & 2","METER 1",IF($C$12="3 & 4","METER 3",IF($C$12="5 & 6", "METER 5",""))) H17 =IF($C$12="1 & 2","METER 2",IF($C$12="3 & 4","METER 4",IF($C$12="5 & 6", "METER 6",""))) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[noelmus]

Hi Joe4,
No problem
Thanks