| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple corresponding Values (Biff.........)
Having trouble getting this formula to work. Im hoping its just something
small I'm missing.....My info is in A98:AB400 the values I want to evaluate are in column C. Here is my current formula: =INDEX($A98:$AB400,SMALL(IF($C$98:$C$400=H6,ROW($9 8:$400)),ROW(98:98)),1) I've tried to change the ranges, the rows and everthing else and I still get error formulas........Please help to end my suffering...... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Biff - SPSS Output Exported as Values and Not Image | Excel Discussion (Misc queries) | |||
| BIFF - Help!! lookup numbers in multiple columns and return one nu | Excel Worksheet Functions | |||
| Biff I need your help!! | Excel Worksheet Functions | |||
| Hello Biff are u here | Excel Discussion (Misc queries) | |||
| To Biff: Using Match with multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
