Conditional load based on whether a Field Name match another fieldname in another Table

[Roelfstr11]

I want all the data if the CompanyNo field in the  GrpSuperTB table matches the 'TB Co No' Field in the TBCN table

Can anybody assist

TBCN:
LOAD
"TB Co No"
FROM [lib://Dropbox - roelfstr@me.com/Keys/Dealerships Companies.xlsx]
(ooxml, embedded labels, table is [Company Key]);

[GrpSuperTB]:

CrossTable(Month,Value,3)
LOAD

[A] as GLNumber,
[B] as CompanyNo,
[C] as GLDescription,

D AS @151,
E AS @152,
F AS @153,
G AS @154,
H AS @155,
I AS @156,
J AS @157,
K AS @158,
L AS @159,
M AS @160,
N AS @161,
O AS @162,
P AS @163,
Q AS @164,
R AS @165,
S AS @166,
T AS @167,
U AS @168,
V AS @169,
W AS @170,
X AS @171,
Y AS @172,
Z AS @173,
AA AS @174,
AB AS @175,
AC AS @176,
AD AS @177,
AE AS @178,
AF AS @179,
AG AS @180,
AH AS @181,
AI AS @182,
AJ AS @183,
AK AS @184,
AL AS @185,
AM AS @186,
AN AS @187,
AO AS @188,
AP AS @189,
AQ AS @190,
AR AS @191,
AS AS @192,
AT AS @193,
AU AS @194,
AV AS @195,
AW AS @196,
AX AS @197,
AY AS @198,
AZ AS @199

FROM [lib://Dropbox - roelfstr@me.com/Daily Data Deposits/GRPTBALL.xlsx]
(ooxml, no labels, table is Sheet1);

[vinieme12]

as below, using Exists()

TBCN:
LOAD
"TB Co No" as [B] 
FROM [lib://Dropbox - roelfstr@me.com/Keys/Dealerships Companies.xlsx]
(ooxml, embedded labels, table is [Company Key]);

[GrpSuperTB]:

CrossTable(Month,Value,3)
LOAD

[A] as GLNumber,
[B] as CompanyNo,
[C] as GLDescription,

D AS @151,
E AS @152,
F AS @153,
G AS @154,
H AS @155,
I AS @156,
J AS @157,
K AS @158,
L AS @159,
M AS @160,
N AS @161,
O AS @162,
P AS @163,
Q AS @164,
R AS @165,
S AS @166,
T AS @167,
U AS @168,
V AS @169,
W AS @170,
X AS @171,
Y AS @172,
Z AS @173,
AA AS @174,
AB AS @175,
AC AS @176,
AD AS @177,
AE AS @178,
AF AS @179,
AG AS @180,
AH AS @181,
AI AS @182,
AJ AS @183,
AK AS @184,
AL AS @185,
AM AS @186,
AN AS @187,
AO AS @188,
AP AS @189,
AQ AS @190,
AR AS @191,
AS AS @192,
AT AS @193,
AU AS @194,
AV AS @195,
AW AS @196,
AX AS @197,
AY AS @198,
AZ AS @199

FROM [lib://Dropbox - roelfstr@me.com/Daily Data Deposits/GRPTBALL.xlsx]
(ooxml, no labels, table is Sheet1)
Where Exists([B]);