Returning multiple cells

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!
 
L

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top