match names in 2 different columns

Excellent!! Thanks guys! I tried it both ways! Did exactly what I needed!

Thanks again!

Mike


"Max" wrote:

> The preceding play extracts in col C
> > .. names in col B which are within col A,
> > with all results neatly bunched at the top
>
> If you need to (conversely) match it the other way around
> (i.e. names in col A with those within col B),
> just similarly ..
>
> Place in C1:
> =IF(ISERROR(SMALL(D:D,ROW(A1))),"",INDEX(A:A,MATCH(SMALL(D:D,ROW(A1)),D:D,0)))
>
> In D1:
> =IF(A1="","",IF(ISNUMBER(MATCH(A1,B:B,0)),ROW(),""))
>
> Select C1:D1, fill down to last row of data in col A
>
> Col C will auto-extract the names in col A which are within col B,
> with all results neatly bunched at the top ..
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---

"Mike" wrote:
> Excellent!! Thanks guys! I tried it both ways! Did exactly what I needed!
> Thanks again!

Great to hear that, Mike !
Thanks for the feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---