INDEX COLLECT not working

Options

I am unable to get a value returned using INDEX COLLECT. No matter what I try, I keep getting the IFERROR text "Not Found". I have tried using VLOOKUP as well with the same results.

I have deleted the reference sheet and reuploaded the data to a new sheet and still get the same results. Can anyone help me with this? Below is the current expression.

=IFERROR(INDEX(COLLECT({JobTitle}, {EmpID}, [Employee ID]@row), 1), "Not Found")

Thank you - Ron

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!