VLOOKUP - I think?

KellyB

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

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