Hello all – I’m trying to create a formula that I can use in the right table that references information in the left table and returns the following:

– Name of Character with the highest profession value relative to that profession

I’ve tried INDEX, FILTER, VLOOKUP and CHOOSECOLS and nothing will give me the name of the character for the profession. INDEX was alright but it returned the first character with the highest profession (regardless of being filtered to just a single profession or not) – so it would return Appwarrior for Enchanting instead of Appdk.

Any insights, thoughts?

​ Hello all – I’m trying to create a formula that I can use in the right table that references information in the left table and returns the following:- Name of Character with the highest profession value relative to that profession I’ve tried INDEX, FILTER, VLOOKUP and CHOOSECOLS and nothing will give me the name of the character for the profession. INDEX was alright but it returned the first character with the highest profession (regardless of being filtered to just a single profession or not) – so it would return Appwarrior for Enchanting instead of Appdk. Any insights, thoughts?    Read More

​