Package condition vlookup


Hi, I'm trying to help our loading dock out by taking the cells they would normally just fill out, make it a form that is submitted per package. At the end of the day, look at the summary and send an email to the recipient based on the storage condition. The three storage conditions are 4C, -20C, and -80C, on a connected sheet I have a list of the recipients different fridges based on the different conditions. Is it possible to have a location cell, populate based on the recipient and the storage condition? This is what I've come up with

=IF([StorageConditions]1, = "4c"(true)VLO

OKUP(Recipient1, {Freezerlocation Range 2}, 2, false)

The Vlookup will work, but the if statement doesn't.

Thank you for your help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!