Hlookups......

Cristina Andersen

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.

L_123

Yes, you can use an index(collect()) to have a match with as many criteria as you want.