indexmatch error

PriscillaaPan

I have tried the formula in office and it works fine, but not in smartsheet, why is that? It doesn't show no match or any other error, but it doesn't show the correct result!!!!!!!

😥help me please!

CodyRussell

Try editing Type@row to be [Type]@row and Value@row to be [Value]@row.

Everything else looks accurate.

PriscillaaPan

https://community.smartsheet.com/discussion/comment/416945#Comment_416945

thank u so much, but after I edited, nothing changed😥and when I reopened the formula, [type]became type again

CodyRussell

What error do you get?

If this is a column formula, it could be:

You're using Match([Value Threshold(EUR)]1 instead of Match([Value Threshold(EUR)]@row

It could also be that the cross-sheet reference isn't liking that you have brackets in the references name:

[Value Threshold(EUR)]1 vs [Value ThresholdEUR]1

Can you provide a little more detail about the issue/error message?

PriscillaaPan

https://community.smartsheet.com/discussion/comment/417099#Comment_417099

this is the same formula that works correctly in the Office, on Smartsheet, the only difference is: the data source is from another sheet. The column, now, cannot show the correct answer without mentioning like: REF/No Match

CodyRussell

Hmm, this is tough to say what the issues is without seeing how you have your cross sheet references set up.

Here is a couple things to check:

Have you tried changing the formula to exact matches and seeing if that gives you the correct result?

Also, if you have a formula calculating the value, make sure you don't have an iferror changing the value to blank, this can cause havoc in dependant if statements.

Check that your index and match reference columns are selected in the correct order, and only referencing one column per index and match.