Priority based lookup

[virencm]

Hi Guys,

Looking for some help with formulas to return data that is based on priorities and then the smallest date.

Please take a look at the attachment. I have tried to explain it all in there.

Thanks in advance.

V

[Jacc]

This seems to work:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Glenn Kennedy]

Jacc's formula is neater than this... but it may be delivering the wrong result in the 3rd case...

=IFERROR(IF(INDEX($N$3:$N$8,MATCH(C3,$L$3:$L$8,0))&INDEX($N$3:$N$8,MATCH(C8,$L$3:$L$8,0))="12",C3,C8),INDEX(C$3:C$11,MATCH(MIN(C6,C11),C$3:C$11,0)-3))

and

=INDEX(C$3:C$11,MATCH(C13,C$3:C$11,0)+3)

[Jacc]

I couldn't see HPC Case driver in the list so I just added it.

[virencm]

Thank you Jacc and Glenn!

This is exactly what i needed.

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.