Help with Offset/Index/Match formula

[S Davis]

I recall using this in the past but it has been awhile and I can not
get this to work.

I have a simple table like as below... dates and payperiods:

PPStart PPEnd PPNumber
1/1/2007 1/14/2007 1
1/15/2007 1/28/2007 2
1/29/2007 2/11/2007 3

To be quick and concise, I have two input cells that the user can use
to specify the range of a summary based on the payperiods. If the user
enters 1 as the starting payperiod and 3 as the ending payperiod, I
need to display 1/1/2007 and 2/11/2007.

Essentially I need to offset from the rank to display the dates I
need.

Thank you for any help!

 

[vezerid]

Table headers in A1:C1, data in A2:C4, start payperiod in F1, end
payperiod in G1. For PPStart:

=INDEX(A2:A4,MATCH(F1,C2:C4,0))

For PPEnd:

=INDEX(B2:B4,MATCH(G1,C2:C4,0))

HTH
Kostis Vezerides