how do I use a cell value as part of a cell refereren in a formula
One cell returns a numeric value (ex. 47)
using the match function, I want to use the above numerical value as the row
for the array to search
Example:
'Migration Rules'!$U$47:$AC$47
I tried using the concatenate function, but I could not get it to recognized
the result as a cell reference
|