How to wrap a range in a TEXT() function?

[djarcadian]

=ArrayFormula(iferror(vlookup(C2, sort(filter({DataJobsAllAppend!C:D,row(DataJobsAllAppend!C:D)}, len(DataJobsAllAppend!D:D)),3,0),2,0)))

I'm using the above formula. The DataJobsAllAppend!C:D range should be in text format but the formatting in that range is not consistent. I'd like to wrap the ranges in a text function like TEXT(DataJobsAllAppend!:C:D,"#####") but it doesn't work. Is there a better to accomplish this?

[oeldere]

I bet you get an better an quicker answer, if you add an small excel file, without confidential information.

Please also add the manual result in your file.

Advice

Don't use full column refrences (C:D), since it will slow done the performance.

You could use a range that will always covers the range (e.g. C1:D15000).

[zbor]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread in CS subforum.

Thread Closed.