Multiple values Match formula

[bidsinga]

He,

I want to use multiple criteria for the Match formula. The lookup value can appear in different tables. I want to create something like this:

Match(A1,(L:L,P:P,Z:Z),0)

I'm not sue if it possible anyway, or that there is another sign I have to apply in instead of the comma.

Thanks!

[Jacc]

http://blog.contextures.com/archives...dex-and-match/