Need to hlook up one cell above

[mbhogal]

Hello,

I have the following data:

Jan-16
Feb-16
Mar-16
Apr-16
May-16
Jun-16

I would like to lookup up May-16 and would like the formula to return the cell above i.e. Apr-16.

Can someone please kindly provide a simple solution?

Many thanks in advance.

[JohnTopley]

Is it just one row per month? Are the dates in Date format? why not look for Apr?

Sample file would help us to understand the requirement.

[Khalidngo]

Hi mbhogal,

If you just need previous month based on date in B1, use this:
=EDATE(B1,-1)

Or if you are looking to return the above entry of matched cell, try this:
=INDEX(A1:A6,MATCH(B1,A1:A6,0)-1)

Blessing

[mbhogal]

The =EDATE(B1,-1) formula has worked and meets my requirement.

Thank you everyone for your assistance.