Locating a row in a table of data based on specified parameters

[Marcos Aristotelous]

Hi - I'm looking for some formulas in the attached template to help me locate a date in a table of data, based either on specifying which of a succession of dates I am interested in [the first, second or Nth date] OR, more complicated, to locate a row containing a particular date after specifying some conditions to consider only some of the dates in the data rather than all of them...

Apologies for not framing this question with greater Excel specificity! Your help greatly appreciated.....

[Kaper]

first

=MATCH(SMALL(C8:C20,3),C$1:C20,0)

second array formula (committed with Ctrl+Shift+Enter)

=SMALL(IF(B8:B20="A",C8:C20,""),3)

(person A, 3rd event date)

[RobertMika]

I would rather not hard coded anyhing
So
=MATCH(SMALL(C8:C20,D7),C8:C20,0)
where C7 is your 3,or n-th value to look ap
and
=SMALL(IF(B8:B20=$E$7,C8:C20,""),D7)
where D7 is the attribute.

[Kaper]

Hi Robert,
Have you had a chance to look into the attachment?
There is everything paramerized ;-) but for the sake of readability i wrote hardcoded versions in the text.

May be it is worth noting, that Robert's way:
=MATCH(SMALL(C8:C20,D7),C8:C20,0)
formula will return the number of the row within the table, while my proposition
=MATCH(SMALL(C8:C20,3),C$1:C20,0)
returned the sheet row number

[Marcos Aristotelous]

Thanks to Robert and to Kaper for very clear suggested solutions which I have implemented and which work 100%. Much appreciated.