Hi All,
I'm trying to write a MATCH function in which the beginning row of the array (Argument 2) is based on a variable number (i.e. a number I pull from another cell or get through another MATCH statement). It would look something like this;
=MATCH("rabbit","B"&8:B12,0)
OR
=MATCH("rabbit","B"&MATCH("frog", B1:B12,0):B12,0).
I can do that with INDIRECT[ =INDIRECT("A"&MATCH("Rabbit",$B$1:$B$12,0))]
but it doesn't seem to work with MATCH. Is there a way to set this up so I can have that first cell in the array vary?
Thanks in advance.
ChemistB
Bookmarks