Hi Howard,

Am Fri, 24 Apr 2015 22:17:36 -0700 (PDT) schrieb L. Howard:

So INDEX SMALL formula is the answer.

you copy the formula to the right so you have to use COLUMN for SMALL.

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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional