Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How to index + match with multiple criteria ?
I'm trying to figure out how to do the following excel formula in Smartsheet, but I am having trouble with it. Can I get some help please ?
Basically what I need to do is match 3 different criteria (lookup 1 -3) with 3 different collumns(part 1 - 3) and when those match they have to give me the corresponding Time.
This is the excell formula : =INDEX(D1:D4;MATCH(1;(A6=A1:A4)*(B6=B1:B4)*(C6=C1:C4);0))