Index and Match issues

Hi,

I'm currently working with this formula: =INDEX($V$4:$AT$4,1,MATCH("X",V5:AT5,0)) and this spreadsheet: DCM_market_update_1-15-16 test.xlsm.

I'm working with the columns in blue. Wherever there is an 'X', I want to have the corresponding header returned into column "WMVBDs" and there are multiple companies in some of the rows. In the first row, only "Loop" was returned, but I also need "Ramirez" and "Williams" too.

I'm only a novice and I don't know how to solve this problem....please help!

Thanks in advance!

Try these in U5 and copy down

Formula:

Please Login or Register  to view this content.

It only returned the name of the first company in the row even though there are a few.

Originally Posted by Wikster7

It only returned the name of the first company in the row even though there are a few.

You must copy the formula down.
See the file DCM_market_update_1-15-16 test.xlsm that I send.
I think we should review the organization you want to give your data depending on the result you want to obtain.
If you want to get all the names in the same cell. I suggest you think twice
best regards