Okay just learning this vlookup.
It worked before but now its gives me the following error ##### (#Name?)
this is the formula I used Vlookup(O$5$,Mois,2)
The value entered in O5 is a number between 1 to 12
I defined a table called Mois on a worksheet called Months
Mois = range a1 to b12 which is a 2 colum table.
a1 - a12 = 1 to 12 (number 1 to 12)
b1 - b12 = Jan, Feb, Mar (is the name of the months)
so 1 = Jan, 2 = Feb, 3 = Mar .......
If I edit name I get
Refers to = Months!$A$1:$B$12
Scope = Months
I have attached the workbook if needed
Thanks
It worked before but now its gives me the following error ##### (#Name?)
this is the formula I used Vlookup(O$5$,Mois,2)
The value entered in O5 is a number between 1 to 12
I defined a table called Mois on a worksheet called Months
Mois = range a1 to b12 which is a 2 colum table.
a1 - a12 = 1 to 12 (number 1 to 12)
b1 - b12 = Jan, Feb, Mar (is the name of the months)
so 1 = Jan, 2 = Feb, 3 = Mar .......
If I edit name I get
Refers to = Months!$A$1:$B$12
Scope = Months
I have attached the workbook if needed
Thanks