I need to figure out to apply the Excel VLOOK formula below to a Smartsheet

Options

=IF($K51="Domestic",$X51+VLOOKUP($J51,$K$6:$W$13,S$5,FALSE),($X51+S$14))

This Formula is being used on an event tracker and is and I need to understnd how to create the same condition in Smartsheet

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!