VLOOKUP with numerous arguments

Hello!

I am trying to automate a status column but with look ups on two sheets. I have started the formula but I am wondering if it is possible to do this many arguments in one formula? Has anyone had any success at doing similar?

Blank = Assembly Job assigned to (is blank) sheet 1

Not Started = Assembly Job assigned to (is populated) and start date (is blank) sheet 1

In build bay = start date (is populated) sheet 1

In PD = Assembly complete (is checked) sheet 1

BUILD = PD complete (is checked) sheet 1

Broken down = breakdown complete (is checked) sheet 2

DOMESTIC = Ready for Dispatch (is checked) sheet 2


=IF(OR(VLOOKUP([Serial Number]@row, {Tow and Blow Builds Range 5}, 141, true) = 1), "Built", IF(OR(VLOOKUP([Serial Number]@row, {Tow and Blow Builds Range 1}, 32, true) = 1), "In PD", IF(VLOOKUP([Serial Number]@row, {Tow and Blow Builds Range 2}, 5, true) <> "", "In Build Bay")))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!