Index match returning multiple cells

[froob]

Hi All,

I'm having a bit of difficulty with this one. I'm inputting raw data into a worksheet and using the "text to columns" feature to split it up. However it's not splitting it exactly how i'd like. On another tab I want to do a lookup on that raw data and return multiple cell values based on the criteria.

e.g.

{=Index('Sh int Desc'!$A$1:$Q$100000,MATCH(1,('Sh int Desc'!$A:$A=$A1)*('Sh int Desc'!$B:$B=$B1),0),5)}

I want it to collate and return the values in columns 5 - 20.

Is this possible?

Thanks

 

[Special-K99]

You cant just say I have data, Ive split it up using Text To Columns, its not how I want it.
Provide some example data.

With 30 posts you should know this already.