Forum Discussion

andrewfeenan's avatar
andrewfeenan
Copper Contributor
Sep 19, 2022
Solved

Referring to data in another sheet within the INDIRECT function.

Hi, I am having issues using the INDIRECT function with data in another sheet called 'InputData'.         =IF(B10=0,IF(C8="No","0",INDEX(Table1[X_Coordinates],MATCH(MIN(Table1[Y_Coordinates]),...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Sep 19, 2022

    andrewfeenan 

    Does this do what you want?

     

    =IF(E14=0,IF(F12="No","0",INDEX(Table1[X_Coordinates],MATCH(MIN(Table1[Y_Coordinates]),Table1[Y_Coordinates],FALSE),1)),IF(F12="No","0",INDEX(Table1[X_Coordinates],MATCH(1,(F16=INDIRECT("InputData!N2:N" & InputData!E5 * InputData!F5))*(G16=INDIRECT("InputData!M2:M" & InputData!E5 * InputData!F5))),0)))

andrewfeenan's avatar
andrewfeenan
Copper Contributor
Sep 19, 2022
Yes, they are.
HansVogelaar's avatar
HansVogelaar
MVP
Sep 19, 2022

andrewfeenan 

Does this do what you want?

 

=IF(E14=0,IF(F12="No","0",INDEX(Table1[X_Coordinates],MATCH(MIN(Table1[Y_Coordinates]),Table1[Y_Coordinates],FALSE),1)),IF(F12="No","0",INDEX(Table1[X_Coordinates],MATCH(1,(F16=INDIRECT("InputData!N2:N" & InputData!E5 * InputData!F5))*(G16=INDIRECT("InputData!M2:M" & InputData!E5 * InputData!F5))),0)))

Resources