Forum Discussion

NouraMohamed's avatar
NouraMohamed
Copper Contributor
Sep 15, 2021
Solved

Index/match formula

Hi, I'm lost I've been trying to figure this out 

I want to get MATCH with multiple criteria, I don't know what went wrong 

 

BI & Data Analysis
excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    Sep 15, 2021
    In the formula: {=INDEX(Total_revenue,MATCH(1,(B2=Ticker_symbol)*(C3=years),0))}
    i assume you did enter as a CSE (as evidenced by the curly brackets) and then the names: Total_revenue, Ticker_symbol, and years all refer to corresponding columns on the other sheet with the data.
    My confusion is the B2 and the C3 as shouldn't they be B4 and F8 respectively?
    so it should read:
    =INDEX(Total_revenue,MATCH(1,(B4=Ticker_symbol)*(F8=years),0))
    and enter using ctrl-shift-enter

5 Replies

  • mtarler's avatar
    mtarler
    Silver Contributor
    Sep 15, 2021
    In the formula: {=INDEX(Total_revenue,MATCH(1,(B2=Ticker_symbol)*(C3=years),0))}
    i assume you did enter as a CSE (as evidenced by the curly brackets) and then the names: Total_revenue, Ticker_symbol, and years all refer to corresponding columns on the other sheet with the data.
    My confusion is the B2 and the C3 as shouldn't they be B4 and F8 respectively?
    so it should read:
    =INDEX(Total_revenue,MATCH(1,(B4=Ticker_symbol)*(F8=years),0))
    and enter using ctrl-shift-enter

Resources