Missing Variables

[bob]

An array formula reads as follows:

=AG2 / (((P2 / ('[Team Data.xls]Data'$I / 5)) * '[Team Data.xls]Data'$J) - Q2)

The problem is that the formula is missing the following:
[TeamData]Data!$I is only valid, if E2 in the current file equals a value in
$B in the TeamData file AND and if G2 equals a value in $C.

I need to know how to modify the formula above to include these additional
components. Thank you.

Bob

 

[Eduardo]

Hi,
could you please provide an example will help, is $I valid only if E match a
value in B and G in C, if not which is the result you are expecting

 

[bob]

I have modified the formula below and it returns a value of FALSE when it
should return a value of .171314

=IF(E2=[Team Data.xls]Data'!$B,IF(G2='[Team Data.xls]Data'!$C,AG2 / (((P2 /
('[Team Data.xls]Data'!$J / 5)) * TmFGM) - Q2),))

The values for each variable, beginning with AG2, are =296 / (((2417 /
(19375 / 5)) * 3421) - 406)

Hi,
could you please provide an example will help, is $I valid only if E match a
value in B and G in C, if not which is the result you are expecting

An array formula reads as follows:

=AG2 / (((P2 / ('[Team Data.xls]Data'$I / 5)) * '[Team Data.xls]Data'$J) - Q2)

The problem is that the formula is missing the following:
[TeamData]Data!$I is only valid, if E2 in the current file equals a value in
$B in the TeamData file AND and if G2 equals a value in $C.

I need to know how to modify the formula above to include these additional
components. Thank you.

Bob

 

[Eduardo]

Hi,

=IF(AND(E2==[Team Data.xls]Data'!$B,G2=[Team
Data.xls]Data'!$C),AG2/(P2/('[Team Data.xls]Data'!$J/5)*TmFGM-Q2))

I have modified the formula below and it returns a value of FALSE when it
should return a value of .171314

=IF(E2=[Team Data.xls]Data'!$B,IF(G2='[Team Data.xls]Data'!$C,AG2 / (((P2 /
('[Team Data.xls]Data'!$J / 5)) * TmFGM) - Q2),))

The values for each variable, beginning with AG2, are =296 / (((2417 /
(19375 / 5)) * 3421) - 406)

Hi,
could you please provide an example will help, is $I valid only if E match a
value in B and G in C, if not which is the result you are expecting

An array formula reads as follows:

=AG2 / (((P2 / ('[Team Data.xls]Data'$I / 5)) * '[Team Data.xls]Data'$J) - Q2)

The problem is that the formula is missing the following:
[TeamData]Data!$I is only valid, if E2 in the current file equals a value in
$B in the TeamData file AND and if G2 equals a value in $C.

I need to know how to modify the formula above to include these additional
components. Thank you.

Bob