dear experts i have this problem i'm using a index combined with match to return a value. based on a drop down list with years. it works for 2012 but when i change the year in the dropdown list i get a #NA error.
see attached example file for a better understanding;)
=INDEX('Exp Prod type'!$E$2:$E$61,MATCH(1,('Exp Prod type'!$A$2:$A$61='Overview Renewables'!$A4)*('Exp Prod type'!$B$2:$B$61='Overview Renewables'!$A$2),0))
thanks in advance