Lookup multiple results that has gaps

F

Fin Fang Foom

Hi ,
My data is set-up in format.
A B D
E
Hours DeptName Criteria Expected
Results
B
8.34
8.34 A
7.21
7.64
3.21
7.21
6.64
3.21
6.62
8.34 B
7.21
3.21
9.21 C
4.15
8.34
10.11

Column A has the hours.

Column B has the Dept Names

Cell D2 Has the criteria

I would like a formula that returns multiple results for Dept B in cell
E2 and filler down.

I could use this formula:

=INDEX(A$3:A$80,SMALL(IF(B$3:B$80=D$2,ROW(A$3:A$15)-ROW(A$3)+1,""),ROWS(A$3¬:A3)))


But if you notice that in column B has gaps between them anyway we
could go around that?
 

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

Lookup multiple results with gaps 8
Lookup Multiple results has gaps 0
Lookup multiple results with gaps 3
Multiple Criteria Lookup 3
Returning a Date with Multiple Criteria Lookup Values 0
Lookup Formula 4
lookup second / last match with two conditions 1
If and LOOKUP - results in multiple columns 6

Top