Need help with index & match formulas

[greykitten]

Hello friends,

I'm working on a sales report where I rank the three products with the largest year over year increase. I've ranked them but I need a formula for the three products with ranking 1,2,3 that will retrieve the name in column B as well as the Y-Y increase in units in column I and the Y-Y % change in column J. I can't figure out which lookup formulas are the right ones (VLOOKUP, MATCH, INDEX) for this task. Cells B60-B62 should have the product name with ranking 1,2,3. Cells C60-C62 should have the Y-Y increase. Cells D60-D62 should have the Y-Y % change. I'm lost on which combination of lookup formulas would be best for this task.

Thank you so much in advance for your help. I really appreciate it.
greykitten

 

[Luke M]

formula in B60:
=INDEX(B:B,MATCH(ROW(A1),$D$1:$D$55,0)-1)
formula in C60:
=INDEX(I:I,MATCH(ROW(A1),$D$1:$D$55,0))
formula in D60:
=INDEX(J:J,MATCH(ROW(A1),$D$1:$D$55,0))

 

[greykitten]

Wow, Luke, thank you so much! You are awesome

greykitten