| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning Multiple Matches | Excel Worksheet Functions | |||
| Vlookup returning multiple answers | Excel Worksheet Functions | |||
| returning multiple cells for a single lookup | Excel Discussion (Misc queries) | |||
| Sort multiple columns with multiple formulas without returning #R | Excel Worksheet Functions | |||
| Returning multiple instances of the same lookup value | Excel Worksheet Functions | |||
Linear Mode
