Hello.Thanks for considering my post. I am using the MATCH function to find
different numerical values within a large number of columns.The columns are
named with an underscore followed by a number : ( _1..._2..._3...).The
column that is chosen to be searched is determined by a random number
generated using the RANDBETWEEN function. I am typing the column name that
is randomly chosen into the range argument for the MATCH function but this
is woefully inadequate.But when I use the ampersand character to combine an
underscore with the randomly chosen column number as the range argument for
MATCH, I get an error ( VALUE!) .I know this is because it recognizes this
as text instead of a number.

How might I rename the columns or in some way get MATCH to recognize these
ranges? Thank you.