INDEX/MATCH/ISBLANK

Options
Nicole D
Nicole D ✭✭✭✭
edited 08/31/23 in Formulas and Functions

Hello,

I'm having trouble with a formula.

I'm looking to return a cell value from an INDEX/MATCH function but if it's blank, to return another cell value from an INDEX/MATCH function.

Company adds travel justification based on employee ID's. If the employee ID hasn't been generated yet (pre hire travel), then the manager's employee ID is used.

This is the formula I am using, however, it's not showing the employee ID when available.

=IF(ISBLANK(INDEX({Source Sheet - Employee ID}, MATCH([Request ID]@row, {Source Sheet - Request ID}))), INDEX({Source Sheet - Manager ID}, MATCH([Request ID]@row, {Source Sheet - Request ID})))

Thank you in advance for your help!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!