VLOOKUP - I think?

edited 12/09/19 in Formulas and Functions

I am doing estimates for projects.  Each job title has its own rate and there are different rates based on specific clients.  What would my formula be if I want to reference a particular cell based on these two parameters.  They would live on a master rate sheet that could be referenced.  


  • Paul.Koetke
    Paul.Koetke ✭✭✭

    Hi Kelly, 

    Sounds like you're going to want to use an IF formula. Something like:

    if(client=a, vlookup(client a rates), vlookup(client b rates))

    This may require multiple embedded IF statements for the number of clients you have. 

    Does this help?

    Paul Koetke

    Upwork - Smartsheet Consultant

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!