Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to look up a value in list & return multiple corresponding val
I have review a proceedure written by Ashish Mathur but I can not get it to
work. It continues to return a blank cell. Even when I copy the exact information the the example he gives -- JW |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to look up a value in list & return multiple corresponding val
Hi Jerry,
Post the procedure and what you are trying to do. Regards, Howard "Jerry" wrote in message ... I have review a proceedure written by Ashish Mathur but I can not get it to work. It continues to return a blank cell. Even when I copy the exact information the the example he gives -- JW |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to look up a value in list & return multiple corresponding
I have a data list which changes constantly depending on the work being
performed. I want to get a total for the individual and the job which is being performed. Data looks similar to this: Employee Job Job 2 Job3 John 5 4 250 chris 2 dave 1 John 3 This continues for 500 rows. I am looking to be able to sum the jobs for each employee. Sub Totals and Filters will not work because this sheet is linked to many other tabs with calculations and vlookups. The proceedure written by Ashish Mathur which is linked in microsoft help under vlookup does not seem to work when I try the exact example. It is however exactly that I need -- JW "L. Howard Kittle" wrote: Hi Jerry, Post the procedure and what you are trying to do. Regards, Howard "Jerry" wrote in message ... I have review a proceedure written by Ashish Mathur but I can not get it to work. It continues to return a blank cell. Even when I copy the exact information the the example he gives -- JW |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to look up a value in list & return multiple corresponding
The equation looks like this
=IF(ISERROR(INDEX(N8:O411,SMALL(IF(N8:N411=N415,RO W(N8:N411)),ROW(1:1)),2)),"",INDEX(N8:O411,SMALL(I F(N8:N411=N415,ROW(N8:N411)),ROW(1:1)),2)) -- JW "L. Howard Kittle" wrote: Hi Jerry, Post the procedure and what you are trying to do. Regards, Howard "Jerry" wrote in message ... I have review a proceedure written by Ashish Mathur but I can not get it to work. It continues to return a blank cell. Even when I copy the exact information the the example he gives -- JW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return multiple corresponding values using INDEX | Excel Worksheet Functions | |||
Function to check list for specific conditions and return an answe | Excel Discussion (Misc queries) | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
Single list from multiple sheets | Excel Worksheet Functions |