Horizontal Lookup on Multiple Rows

[Naru2]

I have a spreadsheet with several years and values working down the page. I'm trying to find a formula where I can lookup a date to the data set, but the date is not always going to be in that first row, it could be several rows down. Then I need the corresponding number below it. So, find the date amongst several rows and then return the value that is 1 row below that. Thanks!

 

[Cubist]

Where's the shipment row?

 

[Naru2]

Row 18 is the Shipment row. I'm attaching the file link again, where you can see the formula is not working for the first 6 months. Thanks!

sample data.xlsx | Powered by Box

app.box.com

 

[Cubist]

1) Your range needs to grab cell starting at A1 you're starting at A3.
2) Your formula isn't updated. Use the one in post #29.

 

[Naru2]

Thank you! Everything is working now. I really appreciate it.

 

[Cubist]

You're welcome. Cheers.