Index Match Excel 2013

[billisnice]

I am still trying to figure out one formula for multi row info.

Column C =INDEX(DB!E:E,MATCH(B2,DB!D:D,0))
Column D =INDEX(DB!F:F,MATCH(B2,DB!D:D,0))
Column E =INDEX(DB!G:G,MATCH(B2,DB!D:D,0))

Is there a way to pull out multi row info without separate index match in each column? I hope i explained it correctly.

[skywriter]

It would be better if you modified your sheet with a before and after view of what you want.
Thanks.

[billisnice]

I am not sure what you ask. I want one formula to pick up multi row info into different columns.

Old - formula for each column
Column C =INDEX(DB!E:E,MATCH(B2,DB!D:D,0))
Column D =INDEX(DB!F:F,MATCH(B2,DB!D:D,0))
Column E =INDEX(DB!G:G,MATCH(B2,DB!D:D,0))

New - one formula to pick up the info I tried this formula and could not get it to work...
Column C =INDEX(DB!E:G,MATCH(B2,DB!D:D,0))

[skywriter]

I am not sure what you ask. I want one formula to pick up multi row info into different columns.

Old - formula for each column
Column C =INDEX(DB!E:E,MATCH(B2,DB!D:D,0))
Column D =INDEX(DB!F:F,MATCH(B2,DB!D:D,0))
Column E =INDEX(DB!G:G,MATCH(B2,DB!D:D,0))

New - one formula to pick up the info I tried this formula and could not get it to work...
Column C =INDEX(DB!E:G,MATCH(B2,DB!D:D,0))

So go into your sheet and hand type what you want the results to be in the cell that you want the results to be in. Make it look like it's already been solved, so we know exactly what you want the results to look like.

[FDibbins]

You mean kike this...
=INDEX(DB!E:E,MATCH($B2,DB!$D:$D,0))

Column C =INDEX(DB!E:G,MATCH(B2,DB!D:D,0))

That wont work. INDEX requires either a single-column range (E:E) or, if you are using an array like that (E:G), then you need to include a 2nd MATCH (or some other value) to indicate the column number

[billisnice]

Is there a youtube on how to set it up to work so i can learn?

Thanks

[FDibbins]

Does that work for you?

[billisnice]

It works for one column, but i would love to learn the array method to save coding. Thanks

[FDibbins]

What do you mean, it works for 1 column?

C2=INDEX(DB!E:E,MATCH($B2,DB!$D:$D,0))
then copied across...
D2=INDEX(DB!F:F,MATCH($B2,DB!$D:$D,0))
E2=INDEX(DB!G:G,MATCH(D2,DB!$D:$D,0))

[billisnice]

In google sheets Column C =INDEX(DB!E:G,MATCH(B2,DB!D:D,0)) will fill in columns e, f and g with just the one formula in E. I guess Excel will not do the same. Thanks for the help!

[FDibbins]

Google does somethings very differently from real excel, I try and avoid using it

[billisnice]

I can not find mark as done button?