Forum Discussion
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 know what may be wrong.
=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.
4 Replies
There are 2 problems
- The formula is written "Year" instead "Years" interval.
- "Year 2 " contains an extra space character.
Just to be easier to understand I would put like this:
=INDEX(Total_Revenue,MATCH(1,(Ticker_Symbol=I4)*(Years=I6),0))Ps.: Depending of your excel version, you can try new formulas such as FILTER() and XLOOKUP().
Find attached
- The year to years solution really made the world of difference. Thank you!
=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!
