SOLVED

Index/match formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2753046%22%20slang%3D%22en-US%22%3EIndex%2Fmatch%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2753046%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20lost%20I've%20been%20trying%20to%20figure%20this%20out%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20get%20MATCH%20with%20multiple%20criteria%2C%20I%20don't%20know%20what%20went%20wrong%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20837px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310605iA085F41D1506AE35%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture1.PNG%22%20style%3D%22width%3A%20801px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310606i72DD9D1ABFFF0118%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture1.PNG%22%20alt%3D%22Capture1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2753046%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2753488%22%20slang%3D%22en-US%22%3ERe%3A%20Index%2Fmatch%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2753488%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1156722%22%20target%3D%22_blank%22%3E%40NouraMohamed%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EConfirm%20the%20formula%20with%20Ctrl%2BShift%2BEnter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2753612%22%20slang%3D%22en-US%22%3ERe%3A%20Index%2Fmatch%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2753612%22%20slang%3D%22en-US%22%3EIn%20the%20formula%3A%20%7B%3DINDEX(Total_revenue%2CMATCH(1%2C(B2%3DTicker_symbol)*(C3%3Dyears)%2C0))%7D%3CBR%20%2F%3Ei%20assume%20you%20did%20enter%20as%20a%20CSE%20(as%20evidenced%20by%20the%20curly%20brackets)%20and%20then%20the%20names%3A%20Total_revenue%2C%20Ticker_symbol%2C%20and%20years%20all%20refer%20to%20corresponding%20columns%20on%20the%20other%20sheet%20with%20the%20data.%3CBR%20%2F%3EMy%20confusion%20is%20the%20B2%20and%20the%20C3%20as%20shouldn't%20they%20be%20B4%20and%20F8%20respectively%3F%3CBR%20%2F%3Eso%20it%20should%20read%3A%3CBR%20%2F%3E%3DINDEX(Total_revenue%2CMATCH(1%2C(B4%3DTicker_symbol)*(F8%3Dyears)%2C0))%3CBR%20%2F%3Eand%20enter%20using%20ctrl-shift-enter%3C%2FLINGO-BODY%3E
New Contributor

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 

 

Capture.PNGCapture1.PNG

5 Replies

@NouraMohamed 

Confirm the formula with Ctrl+Shift+Enter

best response confirmed by NouraMohamed (New Contributor)
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
Thank you
Thank you, that's very helpful.

you are amazing thx

@Hans Vogelaar