Which function to use to return Company Name + Lowest Minimum Weekly Rate
I've tried to use VLOOKUP for this but by having my company names in different columns, i'm not sure what's the best way to return the values I am looking for. I want to review the weekly rates and have it return the minimum of them with the Company Name appearing in column titled "Lowest Rate".
What other formulas would be best for achieving this also?
Help Article Resources
Check out the Formula Handbook template!