View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default Multiple returns with one lookup value


In I2:
=IFERROR(INDEX(Second!$B:$B,SMALL(IF(Second!$A$1:$ A$50=$G2,ROW($A$1:$A$50)),COLUMN(A1))),"")
and insert the formula with CTRL+Shift+Enter
and copy to the right


Regards
Claus B.
--


Aha! Got it.

And the $G2 to pull to the right.
And the G$2 to pull down.

Thanks Claus.