Index & Match function retug # N/A

[howard]

I have numbers in Col A from 1 to 12 and the month and year in Col B on sheet "months"

Book1
	A	B
1	1	Sep-2016
2	2	Oct-2016
3	3	Nov-2016
4	4	Dec-2016
5	5	Jan-2017
6	6	Feb-2017
7	7	Mar-2017
8	8	Apr-2017
9	9	May-2017
10	10	Jun-2017
11	11	Jul-2017
12	12	Aug-2017
13
14
15
16
17
Months

I have tried to set up an index and match function on sheet "fixed Assets" but I get #N/A

Book1
	U	V
1	Period	Month
2	#N/A	March-2017
3
4
5
6
Fixed Assets

Cell Formulas
Range	Formula
U2	=INDEX(Months!A1:A15,MATCH(V2,MATCH(Months!B1:B15,0)))

It would be appreciated if somone could kindly assist me

 

[Scott T]

How are your months entered? As actual dates (3/1/2017) or as Mar-17? And do the match between sheets?

 

[AkaTrouble]

it is returning a fail because the formats are different on you Months sheet it is Mar-2017 and on your assets sheet it is March-2017

 

[Jonmo1]

You can get the month number without the lookup table...

If V2 is entered as a real date, you can get the desired month number like this

=MONTH(EDATE(V2,4))

 

[howard]

My apologies. I was referring to the match in V2, it should be match(U2,

Formula now works perfectly

 

[howard]

Thanks for the formula