Returning multiple cells

  • Thread starter Thread starter bmcgill
  • Start date Start date
B

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!
 
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!
Click to expand...

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
 
Back
Top