Lookup value in list and return value

J

J.W. Aldridge

This is probably something super simple.
But for some reason, i cant figure it out.

I have a list of dates in ascending order. (C2:C1000)
6/20
6/21
6/22
6/23
6/24
6/25
6/26
6/27
etc...

In A:2, i would i want to enter a specific date that is provided in
the date list above.
6/20

and return the value 10rows down.


Any suggestions?
 
N

Niek Otten

=INDEX(C2:C1000,MATCH(A2,C2:C1000,1)+10)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| This is probably something super simple.
| But for some reason, i cant figure it out.
|
| I have a list of dates in ascending order. (C2:C1000)
| 6/20
| 6/21
| 6/22
| 6/23
| 6/24
| 6/25
| 6/26
| 6/27
| etc...
|
| In A:2, i would i want to enter a specific date that is provided in
| the date list above.
| 6/20
|
| and return the value 10rows down.
|
|
| Any suggestions?
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top