multiple a logical result array with a text array and return text

Hi,

I need to multiply an array of logical results ( returned as {1,0,0,0,1,0 et.}) with a text array (a reference column) and return the text in the reference column in case the value in the logical array is 1.

-Sandy

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Unfortunately XL is not very good at generating strings like that... if you do really only have a few possibilities (ie 4 names) then a traditional approach would be something along the lines of:

Please Login or Register  to view this content.

Anything too vast would generally warrant a UDF .. there are quite a few UDF's out there for this type of thing... there's also Laurent Longre's morefunc.xll add-in which has the MCONCAT function which could be used along the lines of:

Please Login or Register  to view this content.