Index match Help on formula

David Clunie

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)), "")

Andrée Starå

Hi @David Clunie

I hope you're well and safe!

What's the default value that it pulls?

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

David Clunie

Hi, it pulls the following row. I have no idea why?

If it cannot find a match, I would expect a blank cell? It's almost grabbing this as a default

Sold subject to Stocking Policy Meeting

Andrée Starå

@David Clunie

Strange!

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)