E
ebensen70
Hi,
I have an array of data that that I am picking values from using the
INDEX and MATCH functions. Is there a way to return more than one
column of data?
example:
10 A B C D
20 E F G H
30 K L M N
40 O P Q R
I want to search for values in column 1 that match a given value and
return the values in columns 2 through 4 using one formula.
Right now I would just do it one column at a time with:
=INDEX($A$1:$D$5,MATCH($X1,$A$1:$D$1,0),2)
and in the next cell to the left:
=INDEX($A$1:$D$5,MATCH($X1,$A$1:$D$1,0),3) and on...and on...
I'm sorry if I have not been clear.
Any help would be greatly appreciated!
Thanks in advance,
Eric
I have an array of data that that I am picking values from using the
INDEX and MATCH functions. Is there a way to return more than one
column of data?
example:
10 A B C D
20 E F G H
30 K L M N
40 O P Q R
I want to search for values in column 1 that match a given value and
return the values in columns 2 through 4 using one formula.
Right now I would just do it one column at a time with:
=INDEX($A$1:$D$5,MATCH($X1,$A$1:$D$1,0),2)
and in the next cell to the left:
=INDEX($A$1:$D$5,MATCH($X1,$A$1:$D$1,0),3) and on...and on...
I'm sorry if I have not been clear.
Any help would be greatly appreciated!
Thanks in advance,
Eric