OK, I'm stumped!
Here is my source sheet
And here is my destination sheet
What I want is...
Column: Contractor A
Return Value From: Source Sheet Company Column
Where:
- Source Sheet, Type Column Matches Destination Sheet Category Coulmn
- Source Sheet Rating Coulmn is the highest value.
Columns: Contractor B & Contractor C
Same as above but 2nd and 3rd highest values.
Any help, I've completely confused myself trying to work it out.
Thanks.