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
Check out the Formula Handbook template!