E

#### ebensen70

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