Returning multiple cells

[bmcgill]

I would like to look at cells A1, A2, A3, A4
If the value of C1=A1 then it displays in separate cells the data from Cells
D1 thru D5, if C1=A2 displays D6 thru D10 etc...

HELP Please!

 

[Lars-Åke Aspelin]

I would like to look at cells A1, A2, A3, A4
If the value of C1=A1 then it displays in separate cells the data from Cells
D1 thru D5, if C1=A2 displays D6 thru D10 etc...

HELP Please!

Select the five cells where you want the result to be.
Then enter the following array formula with CTRL+SHIFT+ENTER rather
than just ENTER:

=OFFSET(D1,5*(MATCH(C1,A1:A4,0)-1),0,5,1)

Hope this helps / Lars-Åke