Want to offset found value using Index

G

Guest

I have a combo box in which I select the current month. The value that I
"index" from the Combo Box shows up in Cell B1. In cell B2 I want to use the
index function as well to give me the previous month, in this example it
would "November." In essence how do I pick a month in my combo box, and then
in a cell it shows me the previous month?

I used to use vlookups by adding another column next to the month list in
column A and writing the previous month, but now I want to use the index
formula.

A1 January B1 December
A2 February B2 November
A3 March
A4 April
A5 May
A6 June
A7 July
A8 August
A9 September
A10 October
A11 November
A12 December
 
D

Domenic

Try the following instead...

=TEXT(EDATE(DATEVALUE(B1&" 1, 2005"),-1),"mmmm")

Hope this helps!
 

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

Similar Threads

Mapping strings to integers 5
Offset with scrollbar 3
Month value 3
No of Days between two dates and offset formula 4
INDEX - MATCH - OFFSET By Reference 2
How to Change Reference 4
Last YTD average in columns with full year of data. 6
vlookup or index/match formula?? 2

Top