INDEX No Match Issue

Fiona Murray

Hello,

I have set-up a Smartsheet that links to another Smartsheet through INDEX matching. I use the same formulas for multiple drop-down selections that work properly on most but not on two of the selections. Do you have any recommendations to fix this issue?

Ryan Sides

Hi @Fiona Murray the #NO MATCH error is displayed when it can't find your Staffing Type on your other sheet. Can you double check the spelling on both sheets to make sure it exists on the other sheet?

Fiona Murray

Hi Ryan, thanks that worked! Looks like I updated the names on one sheet but not the other. :)

Ryan Sides

@Fiona Murray ah yes! Glad you found it 😀