| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to lookup a value in a list and return multiple corresponding
I have tried over and over to put in the formula to return multiple values.
I have spent the last several hours trying to figure this one out, and I am at wits end. I got it to return a value but it is not correct. I am not sure why it is even returning that one vallue. I have two sheets in one workbook. One sheet has my data, the second sheet has the lookup value to look up on the data table. Where could I get more help. It seems I am getting the wrong value and also only one value per cell. This is the formula I have entered: " =INDEX('Sales TRX smartlist'!$B$1:$B$2482,SMALL(IF('Sales TRX smartlist'!$A$1:$A$2482='Aug All'!C4,ROW('Sales TRX smartlist'!$A$2:$A$2482)),ROW('Sales TRX smartlist'!1:2482))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup one value in list and return multiple results | Excel Worksheet Functions | |||
| lookup list return diff?? | Excel Discussion (Misc queries) | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| Lookup a value in a list & return multiple corresponding values | Excel Worksheet Functions | |||
| Lookup values in a list and return multiple rows of data | Excel Worksheet Functions | |||
Threaded Mode
