Match Text from one sheet to another and return text

[jbaergen]

Hello - can someone help me with the attached sample file?

I need to take the name of a school in (sheet 1,column E), search a list of school names on (sheet 2,Column A) to find that name, and return the corresponding cohort name from (sheet 2,column B) to (sheet 1,column F).
I've included 6 examples, but our raw data sheet has 271,509 entries (student info attached to school info).

Thanks!
jb

[Bishonen]

shall all names be searched or only a selected one?

[K m]

Try this in cell F2

=INDEX(Cohorts!A:B,MATCH(E2,Cohorts!A:A),2)

Copy formula down

[Bishonen]

Please Login or Register  to view this content.

[FDibbins]

=vlookup(E2,Cohorts!$A$2:$A$6),2,false)

[jbaergen]

All names.

[FDibbins]

so make up a table with all names, and then apply that formula

[Kumail Rizvi]

Hello!
How can I count specific word in different rows and in one column

Thanks
SMKR