Returning multiple cells
 

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!

Returning multiple cells
 

On Thu, 7 Aug 2008 12:22:12 -0700, bmcgill
wrote:

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