Hey everyone. Im trying to figure out a way to do a two or maybe 3.... way match. Id like to set it up to where each month a task is run that does a lookup and places the appropriate value on the month. So for instance, in March, I'd like to see 8000 next to coding 234 50613. Is this possible in Smartsheet? I know it is in Excel just not sure here.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!