Which function to use to return Company Name + Lowest Minimum Weekly Rate

Hey Everyone,

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!