Google Spreadsheets: match multiple variables in multiple columns using match -

google spreadsheets: trying match multiple variables in multiple columns

i have tried code

=match(t7&c7&"v";t$2:t6&c$2:c6&k$2:k6)

that expected woork, not .... ideas how can this?

try this:

=arrayformula(match(t7&c7&"v",arrayformula(transpose(split(concatenate(t$2:t6&c$2:c6&k$2:k6&"|"),"|"))),0))

if not work, please give example of data

Script