Index: Match with symbol values

Jörg Schmidt1

Hi,

Index:Match does not work with my column "Kundenrelevanz" (symbols) neither if I use "1,2,3" nor "one, two, three"

any Idea 😉🙄

Paul McGuinness

Hello @Jörg Schmidt1

The correct format for use in your formula is Empty, one, two, three, four and five.

Quotation marks need to be used around the description.

This is a text reference so wont work directly in equations.

Hope that helps

Thanks

Paul

Jörg Schmidt1

Hi Paul,

sorry but it does not work with Index:Match neither in Geman or english, nor with or without quotation marks.

Remember I use a reference sheet - see above.

Has anyone another idea? 😉