Forum Discussion
Solved
Match Function help
I am using this function with my excel formula =INDEX(Total_Revenue,MATCH(1,($I$4=Ticker_Symbol)*(I$5=year),0)) it is not matching correctly and giving me a N/A. This is a link to it. Please let me k...
=INDEX(Total_Revenue,MATCH(1,(I4=Ticker_Symbol)*(I5=Years),0))
Is this what you are looking for? I adjusted the named ranges "Years" to =projectdata!$B$2:$B$1711 and Ticker_Symbol to =projectdata!$A$2:$A$1711 and now the formula returns the expected result in my spreadsheet.
=INDEX(Total_Revenue,MATCH(1,(I4=Ticker_Symbol)*(I5=Years),0))
Is this what you are looking for? I adjusted the named ranges "Years" to =projectdata!$B$2:$B$1711 and Ticker_Symbol to =projectdata!$A$2:$A$1711 and now the formula returns the expected result in my spreadsheet.
Thank you just changing the syntax of my years really did the trick!