View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
solar+CSE solar+CSE is offline
external usenet poster
 
Posts: 1
Default Index with mulitple value returns and muliple column returns

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.