Index match Help on formula

Options

Hi All

I have an index match formula that pulls info from another sheet from a status column made up of a drop-down with fifteen values. This is restricted to values.

When I find the corresponding match, the formula works great, but if a value is not found, It returns a default value, which is not specified.

I would expect all the rows with Sold subject to Stocking Policy Meeting to be blank as there is nothing to return as it cannot find a match.

Any help, please? I'm not sure why it pulls that value as there are fourteen others it could select from.


=IFERROR(INDEX({HT STATUS}, MATCH([QN Ref]@row, {HT QN}, 0)), "")

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!