Index / Match

[bosco2]

I am using index / match to find a value on a different sheet based on 2 criteria.

Please Login or Register  to view this content.

Is there a way to return multiple cells. For example is the above function returns the value in C4 I would like to copy C4:C100?

Can this be altered to accommodate? Or put into a routine?

Thank you in advance.

[bebo021999]

Have you tried to copy C4 down? Do they give correct results?

[bosco2]

Pasting down it returns the correct value but I want to use the index/match to return multiple cells in a row.
So row2 might return C4:C:100; row3 might return C7:C100, etc.

[FDibbins]

For that, you would probably need to use an ARRAY something like this...
'=IFERROR(INDEX($A$4:$A$23,SMALL(IF(B$4:B$23="xxx",ROW($A$4:$A$23)-3),ROWS($A$1:A1))),"")

To offer more specific suggestions, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[bebo021999]

Can you upload a small sample with your desired results/format?