Excel help INDEX MATCH w/ division and subtraction

S

sfrederick87

Joined
Sep 30, 2022
Messages
1
Reaction score
0
hello, trying to calculate growth margin with formula below but not working please help!!!


SUM(INDEX((((total_revenue, MATCH(1, (ticker_symbol=Ticker_symbol2)*(years_list=year_2),0)/SUM(INDEX (total_revenue, MATCH(1, (ticker_symbol=Ticker_symbol2) *(years_list_list=year_1),0))-1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Weighted randbetween text list 3
INDEX - MATCH - OFFSET By Reference 2
index match help 4
INDEX & MATCH 1
IF, INDEX and MATCH 1
Excel Any excel Wizards? Please help, can't find answer in any threads 2
Excel Returning Multiple Results (closest Match Not Exact) From A Table Using Multiple Criteria 1

Top