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.
|