formula IF

[iraidotel]

Dear All, experts xls
I use .xlt 2003 and would like to make the following formula
the E6 is the starting point entering a value
H6 to H10 is a range of values
I6 until I 10 is Description
F6 is a formula that will make
If the results of its formula will be written Description its course.
Please help

Regards, Ira

 

[Khalid NGO]

Hi Ira,

Try any of the following:
=CHOOSE(MATCH(E6,{0,2.1,5.1,7.1,8.1},1),"SS","CO","MS","KL","MS")

=INDEX(I6:I10,MATCH(E6,{0,2.1,5.1,7.1,8.1},1))

=LOOKUP(E6,{0,2.1,5.1,7.1,8.1},I6:I10)

Regards,

 

[bosco_yip]

Or,

=MID("SSCOMSKLMS",MATCH(E6,{0,2.1,5.1,7.1,8.1})*2-1,2)

Regards

 

[iraidotel]

I already follow the formula given
but has not been successful,
whether the formula is directly input in his xls
thank you
Regards, Ira

 

[Khalid NGO]

I already follow the formula given
but has not been successful,

Hi,
What do you mean by not successful? are the above formulas giving wrong results or giving error?

I have include all above posted formulas in the attached, please check.

Regards,

 

[iraidotel]

Thanks Khalid

 

[Khalid NGO]

Welcome dear, happy to help
Keep visiting.