How to look up a value in list & return multiple corresponding val

G

Guest

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
 
L

L. Howard Kittle

Hi Jerry,

Post the procedure and what you are trying to do.

Regards,
Howard
 
G

Guest

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
 
G

Guest

The equation looks like this
=IF(ISERROR(INDEX(N8:O411,SMALL(IF(N8:N411=N415,ROW(N8:N411)),ROW(1:1)),2)),"",INDEX(N8:O411,SMALL(IF(N8:N411=N415,ROW(N8:N411)),ROW(1:1)),2))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to look up a value in a list and return multiple corresponding 4
How to look up a value in a list and return multiple corresponding 2
How to look up a value in a list and return multiple corresponding 1
Look up and return data 2
Finding Corresponding Cell Value 2
Look up one value and return multiple corresponding values 3
Look up, return value 5
look up a value from a range and return several corresponding valu 1

Top