Table Array Argument in VLOOKUP Function

Hi All,

I couldn't understand table array(highlighted in red) in the below formula. Can anyone explain me?

LOOKUP(2,1/('PL 1'!M15:M54&'PL 1'!N15:N54=48&adctype),'PL 1'!O15:O54)

It gives me the result as "048BDT0200"
adctype is a name with value 200

M	N	O
48	50	048BDT0050
48	100	048BDT0100
48	150	048BDT0150
48	200	048BDT0200
48	300	048BDT0300
48	500	048BDT0500
48	750	048BDT0750
48	1000	048BDT1000
60	50	060BDT0050
60	100	060BDT0100
60	150	060BDT0150
60	200	060BDT0200
60	300	060BDT0300
60	500	060BDT0500
60	750	060BDT0750
60	1000	060BDT1000
110	50	110BDT0050
110	100	110BDT0100
110	150	110BDT0150
110	200	110BDT0200
110	300	110BDT0300
110	500	110BDT0500
110	750	110BDT0750
110	1000	110BDT1000
125	50	125BDT0050
125	100	125BDT0100
125	150	125BDT0150
125	200	125BDT0200
125	300	125BDT0300
125	500	125BDT0500
125	750	125BDT0750
125	1000	125BDT1000
220	50	220BDT0050
220	100	220BDT0100
220	150	220BDT0150
220	200	220BDT0200
220	300	220BDT0300
220	500	220BDT0500
220	750	220BDT0750
220	1000	220BDT1000

Thanks in advance

Ramana

Thanks for quick reply.. :-)

I understood that red color part returns array of true(1) and false(0) and finally it returns 6 as you explained.

However, i didn't understand how & and = symbols are working.

=LOOKUP(2,1/({a,b,a,a,b,a,n}=a),{1,2,3,4,5,6,7})

my question here is... how we are getting array {a,b,a,b,a,n} if we applicable to above example.

Thanks

Ramana

Hey... I understood. Thanks a lot.