IFERROR LOOK UP

Options

Hi All

For our timesheets we use IFERROR to check another sheet against a job number, I now need this to check over multiple sheets not just 1 how can I do this please?

The current formula is below.

=IFERROR(INDEX(COLLECT({PMYS Job Tracker - Boat}, {PMYS Job Tracker - WIP}, WIP@row, {PMYS Job Tracker - Line}, Line@row), 1), "Job Not Found")

I need it to check 1 other sheet.

Thank you

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!