B
bc4240
Is there a way to return an array value in excel through a function or
by reversing a function. I need to do an lookup of a name in a row,
and then have a cell from the row return it's corresponding column
array. e.g (row 1, cell 4 (Bob) = $D$1:$D$500.
I need to be able to use the result in another function like a Match/
Index
I have been able to produce the effect using substitute and address
embeded functions. But I cannot use the result as the array for a
Index/Match. I think because it's just text and not the actual defined
array.
I would like to use the result to fill in the $J$15:$J$509 array below
=INDEX($J$15:$J$509,MATCH(B6,$I$15:$I$509,FALSE),1)
by reversing a function. I need to do an lookup of a name in a row,
and then have a cell from the row return it's corresponding column
array. e.g (row 1, cell 4 (Bob) = $D$1:$D$500.
I need to be able to use the result in another function like a Match/
Index
I have been able to produce the effect using substitute and address
embeded functions. But I cannot use the result as the array for a
Index/Match. I think because it's just text and not the actual defined
array.
I would like to use the result to fill in the $J$15:$J$509 array below
=INDEX($J$15:$J$509,MATCH(B6,$I$15:$I$509,FALSE),1)