Hi,

why not apply a AutoFilter on the column with A, B,... and filter for A.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"solar+CSE" wrote:

Using
=INDEX(Sheet2!$A$1:$B$67,SMALL(IF(Sheet2!$A$1:$A$6 7=Sheet1!$A$2,ROW(Sheet2!$A$1:$A$67)),ROW(1:1)),2)

Is there a way to return multiple column values from the same row?

1 2 3
A w x y
B q r s
A m n o

I want the return values to read across a row if looking for A:
w x y
m n o

Thanks for any help.