Using Match/Index to bring multiple values

J

javi07

New member
Joined
Dec 24, 2014
Messages
2
Reaction score
0
Points
0
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!
 
More clear if you upload your sample problem workbook, not need with real data, just small with fake data but that enough describe your problem, click "Go Advanced" button, and click on paperclip button to attach your file.

Thanks
 
Attached you'll find 2 files. One with the list of items, the other with a code example I'm using.
The user types a Part Number, and the sheet finds the information in the list provided. What I would like, instead of typing the match/index formula in each column, is find the way to bring all the row information to one cell.

Thank you!
 

Attachments

  • example list.xlsx
    65.4 KB · Views: 41
  • example.xlsx
    70.8 KB · Views: 40
With the amount of detail on each row, I presume that your only wanting to pull out certain columns from the full width of the dataset. Why don't you create an extra column combining all those needed and index that ?
 
in say d1 to g1 part_description new_part_flag price_change_flag country
c2=
E00IELL

then in d2 filled across
=INDEX('[example list.xlsx]Sheet1'!$A$2:$AM$30000,MATCH($C2,'[example list.xlsx]Sheet1'!$A$2:$A$30000,0),MATCH(D$1,'[example list.xlsx]Sheet1'!$A$1:$AM$1,0))

not sure what you mean about "in one cell"
 
You must log in or register to reply here.
Back
Top