Hi Smartsheeters,

Naveen Ravi

main sh.PNG

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.

reference shhet.PNG

David Joyeuse

Hi @Naveen Ravi

What you're looking for is this:

=VALUE(INDEX({IC Hourly Cost Range}, MATCH([Market]@row, {Market Range First Sheet},0))) * VALUE([Hours]@row)

Hope it helped!