INDEX / MATCH - Do I have to enter a MACTH value in " "?

Berto_DA

I have an INDEX / MATCH that works fine if I enter the MATCH value in quotation marks…

But if I want to use a cell reference instead…

…I get NO MATCH.

So I guess the only way this works is if we use text in quotes?

Brian_Richardson

It’s likely that Trace is a number but Predecessors is text. In your formula replace Trace@row with Trace@row+””

If your Predecessors might have multiple numbers in it you can instead replace Trace@row with CONTAINS(Trace@row, @cell) in your formula

Berto_DA

It worked! Thanks.