Hi Smartsheeters,


Can you please help me to create a formula, As in main sheet according to market, it should look up in reference sheet, for example: if in main sheet the Market is Spain , then we have look up in reference sheet , it should match the market row then it should multiply HOURS COLUMN IN MAINSHEET * IC hourly cost in reference sheet.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!