IF Statement help to display differe text for different results

[BlueEagle]

Morning All = Hope you are safe and well

I'm having difficulty putting the following into an IF statement...basically when the value changes a letter from the range A - G I want the appropriate text to display - how can I do this?

(H3="A","As New - Asset is in good operational condition. with no defects and/or within warranty period","")
(H3="B","Good - Asset is in good operational condition, with no recent defects and out of warranty period. No evidence of significant degradation.","")
(H3="C","Acceptable - Asset is in good operational condition, with no recent defects and evidence appropriate maintenance has been carried out. Minor repairs may be required.","")
(H3="D","Poor - Asset showing signs of wear, may require refurbishment or upgrade within the next 3 to 5 years. Increased reliability issues not managed by planned maintenance.","")
(H3="E","Unacceptable - Asset failure, awaiting repair approval. Major refurbishment/overhaul required. Non compliant against statutory requirements.","")
(H3="F","Beyond Expected Lifecycle - Asset in poor condition and beyond its expected Lifecycle","")
(H3="G","Asset Not Required - Asset is redundant, not required. Asset to be decommissioned.","")

[AliGW]

Create a lookup table with the criteria, then use a simple VLOOKUP:

I3: =VLOOKUP(H3,$A$9:$B$15,2,0)

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F	G	H	I	J
1
2
3								E	Unacceptable - Asset failure, awaiting repair approval. Major refurbishment/overhaul required. Non compliant against statutory requirements.
4
5
6
7
8
9	A	As New - Asset is in good operational condition. with no defects and/or within warranty period
10	B	Good - Asset is in good operational condition, with no recent defects and out of warranty period. No evidence of significant degradation.
11	C	Acceptable - Asset is in good operational condition, with no recent defects and evidence appropriate maintenance has been carried out. Minor repairs may be required.
12	D	Poor - Asset showing signs of wear, may require refurbishment or upgrade within the next 3 to 5 years. Increased reliability issues not managed by planned maintenance.
13	E	Unacceptable - Asset failure, awaiting repair approval. Major refurbishment/overhaul required. Non compliant against statutory requirements.
14	F	Beyond Expected Lifecycle - Asset in poor condition and beyond its expected Lifecycle
15	G	Asset Not Required - Asset is redundant, not required. Asset to be decommissioned.

Sheet: Sheet1

The lookup table can be anywhere in your workbook, even on a different sheet.

[BlueEagle]

Id prefer to write it in an IF statement? how could I do this

[AliGW]

Why?

What is the perceived benefit? As a seasoned Excel user, I can tell you that the disadvantages will outweigh the benefits, but if you insist ...

=IF(H3="A","As New - Asset is in good operational condition. with no defects and/or within warranty period",IF(H3="B","Good - Asset is in good operational condition, with no recent defects and out of warranty period. No evidence of significant degradation.",IF(H3="C","Acceptable - Asset is in good operational condition, with no recent defects and evidence appropriate maintenance has been carried out. Minor repairs may be required.",IF(H3="D","Poor - Asset showing signs of wear, may require refurbishment or upgrade within the next 3 to 5 years. Increased reliability issues not managed by planned maintenance.",IF(H3="E","Unacceptable - Asset failure, awaiting repair approval. Major refurbishment/overhaul required. Non compliant against statutory requirements.",IF(H3="F","Beyond Expected Lifecycle - Asset in poor condition and beyond its expected Lifecycle",IF(H3="G","Asset Not Required - Asset is redundant, not required. Asset to be decommissioned.","")))))))

[Pepe Le Mokko]

"Why make things easy when they also work the hard way"....

=CHOOSE(CODE(H3)-64, sentence_1,sentence_2,etc...)