| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index with mulitple value returns and muliple column returns
Using
=INDEX(Sheet2!$A$1:$B$67,SMALL(IF(Sheet2!$A$1:$A$6 7=Sheet1!$A$2,ROW(Sheet2!$A$1:$A$67)),ROW(1:1)),2) Is there a way to return multiple column values from the same row? 1 2 3 A w x y B q r s A m n o I want the return values to read across a row if looking for A: w x y m n o Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Mulitple Carriage Returns Within a Concantenate Formula | Excel Worksheet Functions | |||
| Date returns always returns: 00 January 1900 | Excel Worksheet Functions | |||
| Using INDEX and it Returns a #N/A | Excel Worksheet Functions | |||
| Index with 2 arrays returns error | Excel Worksheet Functions | |||
| SUM(INDEX(MATCH) for a range returns different result than SUM! | Excel Worksheet Functions | |||
Threaded Mode
