Hi all,
i would like to know how to apply an IF condition when referencing another workbook and sheet.
so far i have:
=('[running2020.xlsx]method'!C2:50)
the cells in column C from the spreadsheet 'running' and sheet 'method' start AB.00001.20, CD.00001.20, EF.00001.20, GH.00001.20. I would like all references starting EF and GH to be extracted only.
thanks for any help on this
i would like to know how to apply an IF condition when referencing another workbook and sheet.
so far i have:
=('[running2020.xlsx]method'!C2:50)
the cells in column C from the spreadsheet 'running' and sheet 'method' start AB.00001.20, CD.00001.20, EF.00001.20, GH.00001.20. I would like all references starting EF and GH to be extracted only.
thanks for any help on this