Hi there! I have a problem typing the formula in my excel (Macbook) I've typed : =INDEX(C6:C10;MATCH(B25;B6:B10;0), MATCH(C24;C5:N5;0)) As a formula but I still have the error message "are you typing a formula" Can someone help me fix this problem ? Thank you for your help!

Hi Vincent! Thanks for reaching out. I manage to copy and paste the formula on my end and it seems to be working. Can you please share a safe link (or send an email at team@365datascience.com) containing the excel file in question, so that we can look at it and see how we can solve the problem? Thank you. Looking forward to your answer. Best, Martin

Follow this topic

Vincent Perret

Last answered:

29 Aug 2021

Posted on:

28 Aug 2021

Resolved: Error with the formula Index match match

in Advanced Microsoft Excel / Advanced Excel Functions Index, Match, Match

1 answers ( 1 marked as helpful)

Martin Ganchev

Instructor

Posted on:

29 Aug 2021

Helpful answer

Resolved: Error with the formula Index match match

Submit an answer

related questions