Lookup value and return 1 row below

[Bkisley]

Hello everyone!

I have an easy one, I hope, for you!

I have a vertical list of data (years) in cells A2:A19 on Tab 2
I have a horizontal list of data (years) in cells C5:T5 on Tab 1
I have a horizontal list of data (sales) in cells C6:T6 on Tab 1

I need an equation that does the following - Lookup cell value [A2 on Tab 2] on tab 1 between C5:T5 and return the corresponding value in C6:T6

Example
A2 on Tab 2 = 2019
I need to find where 2019 is in cells C5:T5 on Tab 1 --> let's say it is E5
I need my equation to return the value of cell E6

Let me know if you need anything else!
Thank you in advance

 

[Scott T]

on tab 2 try and copy down.

=INDEX(Sheet5!$C$6:$T$6,MATCH(A2,Sheet5!$C$5:$T$5,0))

 

[Bkisley]

This worked perfectly Scott thank you very much!