Hi There,
I'm trying to use Indirect with Offset. This way trying to match 2 different values.
The formula I am using is as follows:
=OFFSET(INDIRECT("'"&"Analyser list"&"'!"&"A1"),1,MATCH($A$1,INDIRECT("'"&"Analyser list"&"'!"&"A1"):INDIRECT("'"&"Analyser list"&"'!"&"D1"))-1,COUNTA(OFFSET(INDIRECT("'"&"Analyser list"&"'!"&"A1"),1,MATCH($A$1,INDIRECT("'"&"Analyser list"&"'!"&"A1"):INDIRECT("'"&"Analyser list"&"'!"&"D1"),0)-1,20,1)),1)
unfortunately this results in the following error
I understand the error but I don't know how I can make the formula work.
Someone knows how to get this to work? I think the problem is with the Indirect part, but no Idea how to fix it
thanks for the help
I'm trying to use Indirect with Offset. This way trying to match 2 different values.
The formula I am using is as follows:
=OFFSET(INDIRECT("'"&"Analyser list"&"'!"&"A1"),1,MATCH($A$1,INDIRECT("'"&"Analyser list"&"'!"&"A1"):INDIRECT("'"&"Analyser list"&"'!"&"D1"))-1,COUNTA(OFFSET(INDIRECT("'"&"Analyser list"&"'!"&"A1"),1,MATCH($A$1,INDIRECT("'"&"Analyser list"&"'!"&"A1"):INDIRECT("'"&"Analyser list"&"'!"&"D1"),0)-1,20,1)),1)
unfortunately this results in the following error
I understand the error but I don't know how I can make the formula work.
Someone knows how to get this to work? I think the problem is with the Indirect part, but no Idea how to fix it
thanks for the help