Advanced VLOOKUP

Sak2195
Sak2195
edited 11/06/24 in Formulas and Functions

I have a sheet 1 having column object name as ZCONXXX (where XXX are numbers) and another sheet with task name having tasks for execution like “Review and upload ZCONXXX” and I need to update duration in sheet 2 matching object name column in sheet 1 to task name column in sheet 2. Help please

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!