Hi,
I hope i can make it clear to you what I want to do by text:
Given this formula, I am looking at Sheet 2, 3 and 4 in the following part:
Because the sheets may vary, I would like to intend them. So it would look something like Sheet 2 up until sheet X (Lets take 6 for example). I just do not want to insert all my seperate sheets in this formula. How to do this?
Thank you in advance.
I hope i can make it clear to you what I want to do by text:
Excel Formula:
=INDEX(FILTERXML("<F><d>"&SUBSTITUTE(TEXTJOIN(" ";;Sheet2!B1:B5;Sheet3!B1:B5;Sheet4!B1:B5);" ";"</d><d>")&"</d></F>";"//d");MATCH(D8;FILTERXML("<F><d>"&SUBSTITUTE(TEXTJOIN(" ";;Sheet2!F1:F5;Sheet3!F1:F5;Sheet4!F1:F5);" ";"</d><d>")&"</d></F>";"//d");0))
Given this formula, I am looking at Sheet 2, 3 and 4 in the following part:
Excel Formula:
Sheet2!B1:B5;Sheet3!B1:B5;Sheet4!B1:B5
Because the sheets may vary, I would like to intend them. So it would look something like Sheet 2 up until sheet X (Lets take 6 for example). I just do not want to insert all my seperate sheets in this formula. How to do this?
Thank you in advance.
Last edited by a moderator: