Hi there,
I have an issue with choosing the right way of performing an action:
I have a table for scoring the procurement price/quality evaluation results (attached). I need to be able to place MAX (i.e. the best total result) of the 18th row from the 2nd sheet (Scores) into D9 of the 3rd sheet (Feedback). However, based on this maximum, I need to fill all the above D3:D8 cells of the 3rd sheet (Feedback) with the results of that Winner (who got maximum) that are stored in rows 4-7 and 16-17 of the 2nd sheet (Scores), which I would like to ask for help with.
The problem is that I never know which of the suppliers will win and I need excel to be able to understand and fill all the relevant information without any of my assistance (although it only take 20 seconds, I still would like to eliminate that).
If there is a need for any thorough clarification, I am very happy to do it.
Hope anyone can help, I would be extremely grateful.
Bookmarks