Index/Match: Value Return with additional text in front

[Morey]

Hello All,

How do I modify formula below to return value with "Description:" in front? Example Value Return = Description: Cooling System Replacement

=IFERROR(INDEX('Report'!R:R,MATCH(A1,'Report'!A:A,0))&"", "")

Regards,

Morey

 

[Fluff]

Try
="Description: "&IFERROR(INDEX('Report'!R:R,MATCH(A1,'Report'!A:A,0))&"", "")

 

[Morey]

Fluff,

Fantastic... It works.


Appreciated,

Morey

 

[Fluff]

You're welcome & thanks for the feedback

 

[Morey]

The following formula is bringing in the correct data but, does apply date formatting to the Date Value. Formula returns "Awarded: 43553". 43553 should be a date. Anyway to fix formula to account for proper date formatting?

="Awarded: "&IFERROR(1/(1/INDEX('Report'!V:V,MATCH(A1,'Report'!A:A,0))),"")

Regards,

Morey

 

[Fluff]

Try
="Awarded: "&TEXT(IFERROR(1/(1/INDEX(Report!V:V,MATCH(A1,Report!A:A,0))),""),"dd-mm-yy")

 

[Morey]

Fluff,

Try
="Awarded: "&TEXT(IFERROR(1/(1/INDEX(Report!V:V,MATCH(A1,Report!A:A,0))),""),"dd-mm-yy")

Works great... Once again, thank you very much.


Regards,

Morey

 

[Fluff]

Glad to help