Just trying to come up with a formula that helps me do what I want to do in terms of indexing, matching, etc.
I have a row-finding formula that works:
=SMALL(IF($A$2:$A$102=$J2,ROW($A$2:$A$102)),ROW(1:1))
This finds me the Row Number I want.
I have another formula here:
=INDEX(E10:J10,MATCH(M4:R4,E10:J10,0),0)
Notice everywhere that says "10". How do I replace the "10" with the SMALL formula above, so that the formula can be the variable I want. I don't want the "10", I want the Small formula to find the row I want.
I know how to do it in VBA, but the & and the "" method isn't working. Must have forgotten this or I am just missing something.
Thanks.
I have a row-finding formula that works:
=SMALL(IF($A$2:$A$102=$J2,ROW($A$2:$A$102)),ROW(1:1))
This finds me the Row Number I want.
I have another formula here:
=INDEX(E10:J10,MATCH(M4:R4,E10:J10,0),0)
Notice everywhere that says "10". How do I replace the "10" with the SMALL formula above, so that the formula can be the variable I want. I don't want the "10", I want the Small formula to find the row I want.
I know how to do it in VBA, but the & and the "" method isn't working. Must have forgotten this or I am just missing something.
Thanks.