Index/match formula

[NouraMohamed]

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 

[#2]

@NouraMohamed 

Confirm the formula with Ctrl+Shift+Enter

[#3 · Accepted solution]

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

[#4]

Thank you

[#5]

Thank you, that's very helpful.

[#6]

you are amazing thx

@Hans Vogelaar