User Profile
Mehmed91
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Re: Index and match #N/A
Greetings dear, It worked! and thank you for your cooperation. Unfortunately, it didn't return all correct answers, it returned the most selling teacher in that city regardless of subject, plus in some cases it returned a teacher name that didn't even teach that subject.1.2KViews0likes0CommentsIndex and match #N/A
Greetings everyone! I am trying to create an index/match where it checks the teaching subject in a certain city and returns the most selling teacher in that area, but it keeps returning #N/A Here is the function: =INDEX(Shamal_D[Teacher_name], MATCH(MAX(IF((Shamal_D[Subject]=[@Subject])*(Shamal_D[city]=[@City]), Shamal_D[Sales Count], -1)), Shamal_D[Sales Count], 0)) Please help me.Solved1.3KViews0likes4Comments
Groups
Recent Blog Articles
No content to show