Adding text to a result

[deanblew]

Hi all,

Is there a way of conducting an indexmatch and adding text to the returning result. is 12345 for example...

=(INDEX('[Tracker (2015).xlsx]CCF Status'!$F:$F,MATCH(BN8,'[Tracker (2015).xlsx]CCF Status'!$D:$D,0),0)


The result is 12345 for example...

I want to add a prefix on the result i.e.

Task12345

Thanks,

D

[Phuocam]

Like this:

"Task"&(INDEX('[Tracker (2015).xlsx]CCF Status'!$F:$F,MATCH(BN8,'[Tracker (2015).xlsx]CCF Status'!$D:$D,0),0)

[protonLeah]

You can also custom format the cell with the formula as: "Task " # if the formula is returning a number, or "Task " @ if it is returning a text string.

That way, the results can be used elsewhere without the "Task" prefix.