Hello all,
Using EXCEL 2010. Trying to create KPI matrix for Sports performance.
My long formula says "You've entered too many arguments for this function
The attached WB explains with example .
Cells used are the exact locations in my workbook
Would appreciate a fix please
Use this formula in cell V290 instead:
=IFERROR(INDEX(KPIs!$AG$10:$AN$13,MATCH(R290,Codes,0),MATCH(S282,KPIs!$AG$9:$AN$9,0)),"")
Hope this helps.
Pete
Dont use if's like that it can only go wrong.. you simply missed one closing breaket somewhere, goodluck finding it..
use an index and match formula to find values in tables like that.
=INDEX(KPIs!$AG$10:$AN$13,MATCH('Matrix-1'!R290,Codes,0),MATCH('Matrix-1'!S282,KPIs!AG9:AN9,0))
edit: lol the same answer in 2 minutes must be the right solution then
Last edited by Roel Jongman; 04-27-2019 at 07:59 AM.
"V290"Formula:
Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Thank you all - works great and saves lots of typing (and errors)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks