Hi all,
Working on another sporting formula where Referees required to make one decision involving 2 x teams
If Team #1 infringes, Team #2 is awarded an action; If Team #2 infringes, Team #1 is awarded an action.
Using Vlookup, does not produce the correct Outcome as there is more than one cell to test.
I believe Index(Match may be the solution, but I have not been able to figure out the correct outcome formula.
Hope someone can assist with the right solution please.
See attached WB
Since the INDEX array is Q10:Q28 shouldn't the MATCH lookup_arrays all be P10:P28?
Dave
I have had a look at your workbook and I am afraid I don't really get what you are trying to achieve. Could you manually moxk up the matrix with just the outcomes you are expecting and why?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Doing as I suggest in Post#2 the returns are what I believe you indicate desired.
Fantastic fast response thank you FlameRetired.
That correction sorted out most of one issue. - and one other problem.
The attached updated WB has an additional Tab Matrix-1 (3) with amended formula additional information / discussion. Hope this helps explains better.
When a Code is selected, the formula needs to be able to sort out where the code is located and place (match?) the description into the column E or K.
Last edited by VisionSmart; 05-22-2019 at 06:13 AM. Reason: Changes to WB info
If I now understand correctly try these formulas as in the attached.
In E15:E32In K15:K32Formula:
Please Login or Register to view this content.Formula:Please Login or Register to view this content.
The first formula still returns description 'SPCode' in E19. I believe this is correct. In order to get the expected 'On Report' either B19 or I19 would have to be "Referee Action Code" 'OR'. Currently I19 is "Referee Action Code" code 'SPC'.
Terrific thank you FlameRetired
Looks to be the right solution.
Will do some further testing and advise result in a couple of days
You are welcome. Thank you for the feedback.
Update for FlameRetired
That formula works great thankyou.
I have another formula requirement which I have posted separately
https://www.excelforum.com/excel-for...-solution.html
Last edited by AliGW; 05-25-2019 at 03:36 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks