Double quotes for function when using another function/text as argument

[alek]

Hello,

I try to use theis function:
=MATCH(A1;M1:M10;1)
but I want the letter M of the array argument to generated by another function (like another MATCH.
When using for example:
=MATCH(A1;CHAR(64+13)&1&":"&CHAR(64+13)&10;1)
I get #VALUE! error, as the whole CHAR(64+13)&1&":"&CHAR(64+13)&10 introduces double quotes when evaluated.

How to get rid of the quotes?

 

[Fluff]

You would need to use the indirect function, but it's best to avoid it where possible, as it's slow & volatile.
What exactly are you trying to do?

 

[alek]

As said in the first post, I want the letter M of the array argument to generated by another function, ie have a variable letter for the array. Is there any other way without indirectfunction?

 

[Fluff]

Depends on what exactly you are trying to do & why. This

I want the letter M of the array argument to generated by another function

tells us nothing at all

 

[alek]

ok, I want to change the list that MATCH (the MATCH in the example) searches depending on another MATCH. The first MATCH finds the collumn, second MATCH finds the row. It's going to be like nested MATCHes. I cannot make it more simple than this. I also inclued an example with CHAR function. Can you make the above example work? If you can, then nested MATCHes can work too.

 

[alek]

Think of itlike manual addressing. I tried R1C1 too, but its offset-based, so its not good.

 

[Fluff]

What is the match function that you are using to find the column?

 

[alek]

Can we just stay on topic and answer the well documented question? I I am looking for a solution to the example I set.

 

[Fluff]

I am trying to do that. Whilst you know exactly what you are trying to do & what your data is like, I do not.
So far you have been very vague, which does not help me to help you.
That said you can possibly use something like

=MATCH(A1,INDEX(H1:Z100,,MATCH(B1,H1:Z1,0)),0)