Home » Forums » Open Source Learning Center » Question and Answer

Using Match/Index to bring multiple values

Submitted by javi on 24 December, 2014 - 17:29

Hi,
I'm using the Match/Index formulas to bring values from another sheet. I need to bring many values in the same row (different columns) and the only way I found until now is to index as many times as I need in different cells, which is quite complicated if there's too many columns (I need 15 values from different columns in the same row).

Is there any way I can create some sort of array, list or something like it to bring all the values all together in one cell?

Thank you!
Regards!

‹ Excel Macro To Highlight Every Row Above Every Empty Row Excel error window: file cannot be accessed. ›
»

Hi Javi, If I understand you

Submitted by mec1981 on 30 December, 2014 - 05:23.

Hi Javi,

If I understand you correctly the easiest thing to do is to use the concatenate function on the other sheet to combine all the cells, then copy & paste special ? values onto the sheet you want it?

Regards
Mark

»