Weird behavior with MATCH

Rudy Moons

HI,

I'm trying to build a scoring system but i've got some strange behavior from MATCH.

What i finally did was putting all items in one new grid , the formula in another and this is what i've got?

Formula under Strategic fit : =MATCH([Strategic fit]@row, {New Sheet Range 1})

Formula under priorities : =LEN([Strategic fit]@row) (just to see if the length was an issue)

Any thoughts?

First screenshot are the results, the second the sheet with the data (New Sheet Range 1)

Rudy Moons

SOLVED :)

Needed tot add the option 0 @ the end

=INDEX({Score Value SF}, MATCH([Strategic fit]@row, {Score Strategic fit}, 0))

Rudy Moons

SOLVED :)

Needed tot add the option 0 @ the end

=INDEX({Score Value SF}, MATCH([Strategic fit]@row, {Score Strategic fit}, 0))